User Profile

Collapse

Profile Sidebar

Collapse
AJ2
AJ2
Last Activity: Aug 2 '06, 03:31 AM
Joined: Aug 1 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • AJ2
    replied to Delete Non System Table
    in SQL Server
    in sysobjects table looking for "U" in xtype column (U: user table, S: system table).
    See more | Go to post

      Leave a comment:

    • AJ2
      replied to SQL Profiler hanging
      in SQL Server
      Sounds like you run into an endless loop in your sql stored procedure.
      See more | Go to post

        Leave a comment:

      • AJ2
        replied to DTS Import Update table.
        in SQL Server
        Selecting "Delete rows in destination table" of "Column Mappings" tab in "Column Mappings and Transformations " page will solve your problem. To get to this page click "..." below "Transform" in "Select Source Tables and Views" page.
        See more | Go to post

          Leave a comment:

        • AJ2
          replied to i'm a newbe. please help
          in SQL Server
          Generate SQL script from existing job, then execute the script in your new environment.
          See more | Go to post

            Leave a comment:

          • AJ2
            replied to Data Transfer
            in SQL Server
            Use DTS Import/Export Wizard with MS OLE DB provider for SQL Server. When comes to the screen "Specify Table Copy or Query", choose "Copy objects and data between SQL Server database"
            See more | Go to post

              Leave a comment:

            • AJ2
              started a topic How to export xml in dts "Excute SQL Task" to a flat file
              in SQL Server

              How to export xml in dts "Excute SQL Task" to a flat file

              Hi Guys,

              I included "for xml auto" in sql statement in "Excute SQL Task" and aimed to dump the output to a flat file. I added "ActiveX Script Task" into my package and with the following lines:

              dim strRecord
              dim objFSO
              dim objStream
              dim objResults

              const OUTPUT_FILE = "c:\XmlOutput.t xt"
              const fsoForWriting = 2

              set objFSO...
              See more | Go to post
              No activity results to display
              Show More
              Working...