DTS Question

Hi -

I want to create a DTS to pull data from Text file to a SQL Server Table. The problem is i want to implement some Business Logic in it.

Like the process would involve 2 SQL tables and i want to basically have to update the table data based on the ID that i have to match through other table...like a join...

How is it possible..??

Thanks for any input...

You have two problems SQL Server will see null values because your data is a text file so you need to import the text file to a temp table before moving to your destination table. The second problem is minor if you are in SQL Server 2005 because you will not have the known restrictions and limitations of text data. I have answered this question many times, SQL Server Agent needs Admin permissions and you can use a stored proc to run the DTS package. Try the link below for sample DTS code and if you are in SQL Server 2005 you could get Integration Services code. Hope this helps.

http://www.sqldts.com

sqlsql