DTS: Importing Data... 1

[Sheffield]

Greetings,

I have a *.txt file to import every month. Since my destination table has a column the *.txt file doesn't have, it requires me to Transform the mappings as seen below.

table Cols    *.txt cols
----------    ----------
ID            <ignore>
tvDataID      001
AirDate       002
AirTime       003
Station       004
TimeZone      005
Affiliate     006
City          007
State         008
Program       009
<Empty>       <ignore>
<Empty>       <ignore>
dmaName       012
dmaID         013

Is it possible to save this Transformation so it doesn't have to be repeated each month?

Thanks,

 

[fluteplr]

Just save the import as a dts package.

 

[Sheffield]

Ok. Now how do I direct SQL Server to execute the DTC Package?

I scheduled it to run, but haven't seen any indication of it having done so. Moreover the expected data isn't in the table.

Help...

 

[Sheffield]

..oops. I meant to say, "How do I direct SQL Server to execute the DTS Package I just saved?

I'd like to have it run each time I receive a new *.txt file, which would be sporatically, at best.

...still confused.

 

[MaxZak]

Try with the DTSRUN command:

if you can catch the receipt of the *.txt, launch a command shell with the command line "dtsrun ..." (see the SQL Books Online for the entire range of parameters like server name, DTS name, user name, ...)