The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
0answers
57 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?
1
vote
1answer
604 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 ...
3
votes
1answer
1k 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 ...
0
votes
2answers
231 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 ...
0
votes
1answer
294 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, ...
2
votes
0answers
338 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
429 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 ...