SQL Server dts -- sql server dts

Gauri
2/9/2007 1:25:57 PM

Hi,

I posted a message yesterday but do not see it on the newgroup yet so posting it again though with modification.
My issue was I wanted to export selective rows from a SQL table and I was exporting it to a text file. Till here it's fine.
The issue is when I want to import this txt file back to the same table on the SQL end. Here in the dts interface provided the only options provided in the transformation is Create table, Append or delete entries and copy from source to destination. Since I am not exporting the entire table DElete option will not work for me since I want to delete only selective rows from the table which I will be importing again. Append will not work since it would error out with duplicate key row cannot be inserted. How can I provide here selective deleting of the rows from the source before copying? Is there any way in the transformation tab here?

I know this can be achieved by creating a package since I tried this. The only problem is distributing this package on a Server at some other location. Is there any easy way to do this?

Any help or comments would be greatly appreciated

From http://developmentnow.com/g/103_0_0_0_0_0/sql-server-dts.ht

Posted via DevelopmentNow.com Group

Allan Mitchell
2/9/2007 9:34:45 PM

So you have exported to text file.
Made changes to the text file?
You not want to copy that back in to SQL Server (same DB/Table)

You are using the Import/Export wizard I presume.

This will be next to impossible with the wizard and it is not a whole
lot better in Designer. The thing is you cannot filter the text file so
you will need to at least start out with all of it.

You then have a number of choices.

The top choice would be to stage the text file on the SQL Server in its
own taable and then issue TSQL statements between your real destination
and the "Text File" table.

The other option is to do lookups in the Active Script transform which
could be monumentally slow.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : SQL Server dts