I have created a DTS package which fetches data from a text file into a database table. I want to pass the file name dynamically from which it fetches data. Can I pass the filename dynamically?
I have taken over a SQL 2000 database. I am trying to figure out what a job is doing. Its command is: DTSRun /~....a big hex string.... I have tried to run: DTSRun /~....a big hex string.... /!Y ...
Does a SQL Server job always run on the server, or will it run in the context of the local machine, similar to a DTS package run from Enterprise Manager on the user's machine? The job in question ...
I have an Execute SQL Task that is (hopefully) going to receive a global variable called startDate, which is set to a Date type. A shortened version of the code looks like this: DECLARE @startDate ...