I've had a couple of DTS packages that run as scheduled jobs that worked fine for weeks after they were designed and deployed. They basically query a database and return data for a particular date range, outputting it in the form of text files for transmission to vendors. The first step in each process is to query a process log table t...
I need to pass a % character as part of a parameter in a dts package. The package just errors saying invalidenvironment variable specification. Does anyone have any ideas? ...
I am trying to copy a database from one server to another in id different location, including all the schema, data, DTS Package and Scheduled Jobs. I used Redgates SQL Packager to pack the schema and data.But I am having trouble in packing the DTS Package (which is a very complex one) in simpler way.Please advice! ...
I've been having a reoccurring problem that escapes me at this point. I have a job set up in SQL Server 2k that has a few command steps which are followed up by 4 steps that just call DTS packages on the same server. When it comes to calling the packages, the job fails with no real reason given. Ok fine... Well the thing that I can't...
I'm trying to load data from an external csv file that needs to be massaged before being inserted into a SQL table. Reading the file is fine, but when I try to loop through the stream and load an array using the SPLIT function I get a "Expected End of Statement" error. Do While Not txtFile.AtEndOfStream strText = txtFile.ReadLine ...
Hi, does anybody have any experience writing unit tests for sql server 2000 DTS packages? I about to start working with DTS and jobs, so I want to be able to unit test as much as possible. I guess i could invoke dtsrun.exe via command line , but perhaps someone else has better ideas. Thanks Fede ...
I'm receiving this error while attempting to execute a package: "The connection is currently being used by a task. The connection cannot be closed or reused." Any ideas? ...
Once your databases are converted from SQL Server 2000 to SQL Server 2005, is there any way to compare DTSs on two servers to see if they are still essentially the same? I need to see if my dev and prod are the same, and comparing them manually is really time consuming. If they were still in 2000, I could use the Red-Gate tool DTS Comp...
I have a database schema in SQL 2005 that I want to copy to a SQL 2000 server. It contains tables that have multiple owners. When I try to create a DTS package to transfer the schema I get conflicts because some of the tables have the same name (but different owners). It looks like it is trying to make all the tables to be owned by dbo. ...
I have to work in a DTS environment in 2005 (too complicated to explain) and I have a comma delimited text file that is to be appended to the main table. I'd like to pull the last column in the text file out for the first record and use it as select criteria for a delete command. But how can I do this in the older DTS environment? Her...
I have 2 SQL Task, each calling different stored procedures. The query in each SP is enclosed between BEGIN and END trans. I added "OnSuccess" of task 1 then move to task 2. I also added 'Fail Package On Error" and enabled "Tansactions" at package level. Question - If task2 fails, shouldn't task 1 be rolled back? ...
When trying to edit a package the server doesnt display package contents. When trying to create a new package the Server Explorer shuts down. No error msgs. At the same time I can connect via client tools from a pc and the packages looks fine. Has anyone seen this issue? Rebooting doesnt fix it and the machine has plenty space on all dri...
I believe its possible to run SQL 2000 DTS packages on 2008 with a compatability layer. But is it possible to do the same with DTS packages created on SQL 7? Is there any MS KB or note that points out if this is even a possibility. ...
Guys, We are in the process of migrating from SQL 2000 to SQL 2005. We have hundreds of DTS pacakges, that the development team is reluctant to redevelop using SSIS. When migrating these packages to SSIS, I am faced with a problem - many of these packages read from Excel files. Given that my production Box is 64 bit, I am forced to u...
What did Microsoft rename DTS to for SQL Server 2005 Express Edition? Where is the download link to the SQL Server 2005 Express Edition DTS utility? i've been searching for half an hour, and i can't find a definitive answer. i need to import data from a data source into an SQL Server 2005 Express Edition database. ...
When I try to import Text File into SQL Server 2000 using DTS, it gives me the following error Not enough storage available to complete this operation Any suggestions? ...
I need to find a DTS package that contains a specific table name. There are 200+ DTS packages each with multiple objects in them. My_Prod is the table name. Is there a T-SQL command to find all the DTS packages that reference this table name? ...
My question is similar to Upgrading SQL Server 2000 to 2005 or 2008 - DTS to SSIS but I have a few restrictions that I'd like the community to consider. We have two databases that currently run on SQL Server 2000 and we are being pushed to move off of this in favor of SQL server 2005 (We do not have 2008, it isn't an option). We have...
I have a very old project implemented in (classic) ASP and SQL Server 2000. Because of quality concerns, I've been considering the possibility of implementing some form of automated quality testing. Though, the web pages are ASP the project is really 85% SQL Server stored procedure, functions, views and DTS. (Lots of dependency on DTS) ...
What are the tools available for DTS to SSIS package conversion as part of the SQL servr upgrade and which ones do you recommend?. ...