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 wildcard parameter to DTS pkg?

Author  Topic 

Ravi0435
Starting Member

47 Posts

Posted - 2009-03-09 : 15:32:02

Hi,
I would like to pass a wildcard string to the DTS Package, the package runs fine when i run it by itself passing the wildcard variable 00491% through the packake properties - global variables , but doesn't recognize when i want to pass the same variable through a BAT file(dtsrun)

The Following works:

DTSRun /S "(local)" /N "Report_Client" /L "F:\Interfaces\DTSLog.txt" /A "GroupName":"8"= "00491001" /W "0" /E


The Following doesnot:

DTSRun /S "(local)" /N "Report_Client" /L "F:\Interfaces\DTSLog.txt" /A "GroupName":"8"= "00491%" /W "0" /E

Any suggestions would be appreciated.


thanks,
R


Nothing much that i can do..!!
   

- Advertisement -