I know this is probably something simple but I'm not up on DTS packages. I have a package that runs once a week and then I have to manually run a third party program to update a warehouse. The warehouse program needs an M passed to it to show it's an update to the warehouse and not a complete ...more >>

Hi All, I ran into a problem invoking a DTS package from a different machine. I wonder if anyone can enlighten me on what might cause the problem. First of all, we have this weird arrangement that we created a DTS package in sql 2000 and deployed it on 2000 server. However, we want to invok...more >>

Hi, I finally got the DTP package up and running: - it runs the query - saves it as a txt file to the local server - ftp's it to a remote server I just found out that the txt file has to be unique and follow a certain format: MIOsampleYYYYMMDDHHMM MIOsample = always the same YYYY...more >>

I came accross your thread regarding DTS, i want to reference the dts package's global variables in c# code in order to change values dynamically, can you direct me to a usefull resources? Thanks *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have a application on the test database (my local SQL server). How to copy the DTS packages to the live SQL server. When I import the datbase to the server, it does not copy the DTS packages, only the tables, view and percudures. Any easy way to do it? Many thanks Lyn ...more >>

Is there a way an ActiveX Script Task can use an existing connection object already in the package? The examples I have rely on ADO db connections created by the ActiveX Script Task, causing a maintenance issue when we move packages from one server to another or passwords change, etc. People...more >>

I have an Excel spreadsheet that I'm trying to import into a SQL Server 2000 database. I'm using OpenRowSet to import the data and it works great unless there is data in an Excel cell that exceeds 255 characters. When a cell contains > 255 characters, I get the following error (when run fr...more >>

I'm running an SSIS package via the "start without debugging" option in BI Studio. The package brings in about 300,000 rows and calculates about 30 million rows that it inserts. It's basically creating a table of running totals based on a set of financial transcations. The package should take...more >>

Hi, I keep getting the error "Invalid string format for source file names" when I execute a DTS FTP tesk. It seems to be intermittent. I can successfully FTP from the site manually. I set the properties via a dynamic properties task. I set the DestSite to be c:\ftp and the SourceFileName...more >>

Hi, I know how to get the name of my DTS using the following: sMyDts = DTSGlobalVariables.Parent.Name BUT how do I get the name of the ActiveX Script that I'm currently editing? I need this so I can report accurately to an Error Log table. Many Thanks JD...more >>

Hi: I can't for the life of me see where the problem here-I'm getting a runtime error - "object required - 'objRS'. (referencing the line where I try to access the record set for the first time - the 'FilePath = objRS.Fields(0)' line). The "Intervals_RecordSet" is a global variable that is su...more >>

I need to make sure everything in my multi-step package is one big transaction. I think that I need to check the "Use transactions" package property, and then flag each step to "join transaction if present." Is that true? I recently tried that in another package and the package crashed wit...more >>

We put up our first 64-Bit SQL 2000 Cluster and I wasn't aware that you couldn't schedule DTS jobs. What gives with that? Is there a way to do it manually with a DTSRUN command?...more >>

I need a book, website, anything to get up to speed ASAP on Data Transformation Services and programming in VB Script. We are running SQL Server Enterprise Manager Version 8.00.194. Any help and guidance would be GREATLY appreciated! Thanks!...more >>

Hi all, This one has me stumped, how do you verify the scheduling or run time of an existing dts package Bill *** Sent via Developersdex http://www.developersdex.com ***...more >>

I was curious about the associated pros and cons between DTS packages, SP's and Jobs (executing T-SQL directly). I am using SQL2000. Basically I prefer building everything into DTS packages, and using the workflow functionality to encourage parallel processing (Have a quad and another oct-proc...more >>

I wanted to use sp_OACreate, sp_OAMethod and sp_OADestroy to execute a DTS package from a stored procedure. I had the dba (using the sa account) create a wrapper stored procedure as recommended in http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_10182004.asp....more >>

Hi, I need to move a database from one disk to another ( detach and attach). What will happen to all DTS packages and jobs which use this database when I detach it - will the database name disappear from all connections(catalog property)? Thanks ...more >>

Hi, I am new to Crystal Reports and DTS. What I need to do is schedule a Crystal Report to run thru DTS package. Here is a sample code that I found on google but it doesn't seem to be working. '**************************************** ' Visual Basic ActiveX Script '***************************...more >>

Hi All, This is a difficult situation to explain but I'll do my best. I have a DTS Package which contains a Connection to an OLAP Data Source, a Connection to a Text File and a transformation in between which does the obvious. Prior to the connection to OLAP I modify the MDX Statement (SQL...more >>

Hi, I finally got this DTS thing to work except that when the records are written to the specified text file there is a blank line/carriage return in between each record: Record 1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Record 2 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Record 3 xxxxxxxxxxxxxxxxxxxx...more >>

I would like to save the output file as file_currentdate.txt for the nightly dts run. Currently we have a batch file that renames and copies the nightly created file into the desired folder. Please let me know. TIA......more >>

I am designing a DTS package and I wanted my package to export multiple data items to a CSV file. I am using multiple "Transform Data Tasks" from my SQL connection to a Text File connection. The problem I am having is everytime the package runs a Transform Data Task it overwrites the data in t...more >>

Hello, I am experiencing the following problem with DTS: on a box running Windows XP SP1 and SQL Server 2000 client tools only, I did the following upgrades: - Windows SP2 --> no problem with DTS - SQL Server SP4 --> DTS no longer works (for instance, I cannot export a small table anymor...more >>

Dear all, We have a set of scheduled DTS jobs which run OK for months on SQL2000 SP3. Recently (since mid July) we found them hang up and cannot finish. Symptoms as below :- 1) The hang up only happens on those DTS jobs with ActiveX script steps, while DTS jobs executing plain T-SQL / da...more >>

Hi everyone, I'm trying to create a package to import data from Oracle to SQL Server 2000. For the records being imported, if they already exist in SQL, then UPDATE them, otherwise INSERT them. Can someone show me how this can be achieved please. I think I need to somehow dump the data from ...more >>

I am using SQL Server 2005 April CTP, Visual Studio Beta 2 in Windows 2003 server I have created a DTSX package. Is there a direct way to consume the output of DTSX package in .NET application? Thanks Harini ...more >>

Hi, does it possible to log the DTS execution to a database which is NOT MSDB? I have a VB program which create an inmemory DTS package then execute it, now I want to activate the log but I want to log the execution into a specific database instead-of MSDB. I can do this by code, but its t...more >>

SQL 2000, sp4. There are about 300 old DTS packages created by former programmer. I used "sp_reassign_dtspackageowner" to change owner of the packages and all owners have be changed to my name. But when I make any change to existing package, the owner name changed to former programmer. Is ...more >>

When I attempt to run my DTS Pkg that contains ActiveX task, I get following error: "ActiveX Scripting was not able to initialize the script execution engine" When I run this from another computer, it runs fine. I have tried reregistrate DTS DLLs: Regsvr32.exe "C:\Program Files\Microsoft SQ...more >>

Hi All, Many Thanks in Advance. We are attempting to use the following code to execute an asp page from a sql dts. The problem is the with the xmlServerHttp.send() line we are receiving a connection with the server cannot be made. Is there either a simple error in the code or a better way o...more >>

I've shceduled a job under sa account (I've changed the password though:)),this job access local folder of the box running SQL server.I have added sa to the sysadmin role and it dose have access to the local folder ..How is it possible as *sa* is a sql server account and how it has the enoug...more >>

Successful DTS package fails when scheduled as a SQL Agent job. The package runs only one ActiveX script, which makes a call to a COM DLL that uses DAO to run read-only queries against an Access 2000 .mdb file with workgroup security. Domain\user1 is assigned to the workgroup, and has f...more >>

As said in my earlier query, I am using a DTS package to import data from multiple SQL Server 2000 server database. They are all alike and hence I have a common data pump task. I run a loop to change the connection setting of the source in the data pump task. I have certain lookups defined ...more >>

Hi, I have a DTS package which is used to move data between two SQL Server 2000 databases. My destination table has an identity column. I have a few Lookups defined in the data pump task. My data pump task has three transformations defined, one of which is a copy column and two are ActivX S...more >>

Hi, Are there any T-SQL command for running a package or I must necessarily use dtsrun.exe within my SPs? Thanks in advance, Leila ...more >>