Passing param to DTS via SP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Passing param to DTS via SP

Author

Topic

dhk11
Starting Member

6 Posts

Posted - 2007-05-03 : 15:23:22

I would like to pass a fully qualified file/path/name as the source data to import into a table, but have not quite figured out how to do this using the global variables within the DTS package. So far, I have created command lines to execute the package:
--EXECUTE THE DTS PACKAGE TO IMPORT FILE TO BULK INSERT TABLE
SET @NString = 'dtsrun /S servername /U UserName /P password /N BulkInsertFND009'
exec master..xp_cmdshell @NString

mattyblah
Starting Member

49 Posts

Posted - 2007-05-03 : 16:56:59

I believe /A "global variable" should work. just type dtsrun at the command prompt and it should let you know the syntax for the different switches.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources