DTS Structure File Storage File Generate SQL Script? 1

[christer99]

I have opened a structure storage file, a DTS package, and I know you can generate a SQL script so you can execute the package using OSQL and DTSRun, but I am trying to remember under what tab in Enterprise Manager that the SQL script is generated? I have done it before, but now I can't remember. I thought it was under the General tab, but it is not and I have been looking for 2 hours without being able to find it. This is an example of the output I am looking for DTSRun /N "ImportDataTM18" /V "{F868998E-AEA6-46B5-8318-450D78D6FC8C}" /F "C:\ARP\ImportDataTM18.dts" /W "0" So this code can be generated somewhere when having the DTS package open in Enterprise Manager, but where????

 

[Rhys666]

I thought you could only do this on Packages on the local server (by right clicking on them) or by having a look here...

Hope this helps.

Rhys
The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense Edsgar Dijkstra

Church of the Flying Spaghetti Monster

 

[christer99]

Thanks problem solved.

 

[Rhys666]

No Worries

Rhys
The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense Edsgar Dijkstra

Church of the Flying Spaghetti Monster