tags:

views:

13

answers:

0
Q: 

DTS Add uniqueidentifier to destination with text as source

SQL Server 2000; My source is a text file with the destination also having a uniqueidentifier column. I know how to do this with a database source but don't know how to do it with a text file as the source.

related questions

DTS DB2 Connection Problem
Importing Excel into SS2000; Error on Field; DTS
Catching events from an SSIS package loaded in C#
SQL Server 2000 FTP
DTS- Debugging Tips
Move data accross SQL Servers with DTS packages or linked servers
Open a .BAS DTS Package in SQL 2000?
How can I run sql server stored procedures in parallel?
How do you restore DTS permissions after database restore on SQL 2000
XMLHTTP POST request and System.Reflection
Converting DTS packages to SSIS
What is the best way to execute an MS SQL Server 2000 DTS package from a trigger?
How do I export the SQL statement from a DTS object?
Using SQL Server DTS Package to Conditionally Insert / Update Rows in Destination Table
DTS Packages & a Connection to Access
The SQL Server DTS Connection2 object has an undocumented property, UseDSL. What does it do?
Error when copying a check constraint using DTS
SQL DTS Database Copy Fails
Create SQL Table from Excel spreadsheet
How do you copy a MS SQL 2000 database programmatically using C#?
What Oracle driver should I install in my MS SQL server to be able to use DTS to copy data from the Oracle server to the MS SQL server?
Can the ffmpeg av libs return an accurate PTS?
How to use stored procedures within a DTS data transformation task?
How can I create a human-readable script for every DTS package on a SQL server?
Can DTS Test for Presence of MS-Access Table