The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
356 views

Can't Open SQL DTS Packages

We have a SQL 2008 server. When trying to open DTS packages we'd get this error: "SQL Server 2000 DTS Designer components are required to edit DTS packages." Installing SQL Server 200 DTS Designed ...
0
votes
1answer
214 views

Does Oracle DB has a tool like DTS Wizard in SQL Server?

Is there a tool like the Microsoft SQL Server's DTS (Data Transformation Services) Wizard that simplifies the process of ad-hoc importing of flat files (CSV, TSV, or XLS) to Oracle database? ...
0
votes
2answers
212 views

Automatically set up user's subscription in SSRS

I have a very simple report in SSRS that is just a table with three columns, an object name, client account, and expiration date. In my report, I include a filter by UserID to limit the data to just ...
0
votes
2answers
70 views

Editing Job and DTS on SQL Server 2000

I took over a SQL Server 2000 and need to fix a job that calls 3 DTS packages. How can I cross reference the DTSRun hash to the actual DTS name?
0
votes
1answer
152 views

MS SQL dts to ssis migration error

I have migrated some DTS packages to SSIS 2005 using "Migration" wizard. When I tried to run it, it fails saying you need a higher version of SSIS even though the destination SSIS server is on ...
1
vote
1answer
130 views

Search for text within a DTS file

We have a large store of DTS files which I need to search through for a string of text. Is there any utility which will allow me to do this? Many thanks EDIT: Prefer free/open source as I work for ...
2
votes
1answer
978 views

Getting the ID of a DTS package in SQL Server 2000

I've got a job set up in SQL Agent, with a number of steps. These steps all look like: DTSRun /~Z0x6B7BDADEAD0D381F601ECC24B C0C4C522870C60DC5EC3D012C5D08A8DEB529CE ...