The dts tag has no usage guidance.
3
votes
1answer
3k views
How to figure out what a DTSRun command is doing
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
...
2
votes
1answer
3k views
Creating an SSIS package that uses a stored procedure
We're trying to make an SSIS package where it'll launch a stored procedure and capture the contents in a flat file. This will have to run every night, and the new file should overwrite the existing ...
2
votes
0answers
165 views
How do I pass a parameter in a stored procedure to call a DTS package
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?
2
votes
0answers
439 views
DTS error when a parameter is added to an Execute SQL Task
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 ...
1
vote
1answer
566 views
SQL Server 2000 export database to csv
I need to move an SQL Server 2000 database to MySQL. I'm running into several complications. I'm no expert on SQL Server. To get going I'd like to have a csv-dump of structure and data.
First issue, ...
1
vote
2answers
362 views
Does a SQL Server job run on the server or the local machine?
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 ...
1
vote
1answer
15 views
dtsinstall.exe does not deploy packages
I created SSIS project solution in VS2008.
I created 5 packages and deployed them to SSIS Storage succesfully.
I executed 4 packages successfully.
I leave SQL server few days alone (holiday!).
I ...
1
vote
1answer
639 views
How to sync a table between oracle and sybase
I have a table in Sybase (destination) that I would like to keep it synced with a table in Oracle (source)
I cannot truncate and populate the table in Sybase because it is used by an application, I ...
0
votes
1answer
36 views
DTS Type Mismatch at Join
I am new to ETL and VB in general and need some help resolving this issue. I have looked online and found some interesting answers but none seem to be working for me.
varamt = Lookup (
...
0
votes
1answer
16 views
Permissions To Update Legacy DTS Packages
I am trying to grant access to allow users to view and update existing legacy DTS packages. The problem is that they cannot see the needed nodes under Management to begin working on them. I've tried ...
