To Call DTS:1) use dtsrunui.exe (in 80/tools/bin under SQL Program Files) to generate a DTSRun command string. Set variable FY="default value" to generate global variable portion of command line.2) Copy command line and set a varchar variable in proc to that value.3) replace "default value" in string with a "server" parameter from proc (using string concatenation)4) exectute […]
2005-04-08
You're right - it is not actually running. I thought I had configured it properly but I guess I didn't. Now I feel silly. But what format would the file be in? Is it .trc?
2003-12-08
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers