HI all: i have a existing dts package and i tried to add more tasks in this dts package and save it. but when i open the dts package again , those changes does not exist at all. I tried severals times, still same results. is that any property that i didn't...more >>

I have created a package that just export a number of tables to an Access Database and it works fine. However, when I rerun the package, I get error message as it cannot create the tables (This is because they are already exists in the Access database). What is a better way for me to handl...more >>

Can someone help with a code that will automatically re-execute a failed package.., try to re-execute it three (3)times, then exit if failed after the third time. can someone help with a code? Thanks -- Message posted via http://www.sqlmonster.com...more >>

Well, certainly I'm the stupidest human being on the face of the earth. And, alas, there is no booby prize for this honor. All I want/need to do is copy some data from an Oracle db (7.3.4) to a Sql Server instance (2000 sp3) where said data is > #this date#... I want to select the max(date) ...more >>

I am trying to use DTS to import a text file with no field delimiter using fixed length fields. Imporing rows with less than the max possible row length ignore the row delimiter and data from multiple fields end up in the same record. I've seen similar issue in the KB but not this exactly. ...more >>

I am looking for a good DTS book. I already have intermediate experience with DTS. I found a couple: http://www.amazon.ca/exec/obidos/search-handle-form/702-1827749-1940062 Which one would you recommend?...more >>

Server 1 Production Server 2 Test a) detach files on server 1 b) copy files from server 1 to 2 c) attach files on server 1 and 2 /Michael V. ...more >>

Hello, I'm got a subdirectory containing a large number of flat files. I want to use DTS to recursively import them into a database, using a DTS package that iterates through the subdirectory, creating tables with the same names as the files being imported. I'm using SQL 2000 on W2K machines....more >>

Hi , I have some DTS packages to transfer data from text files on different computers to SQL server tavles. Now I need information about these package name, the source of the text files and output tables, I want to have table to hole all these data. I am sure there is a way to do it. I loo...more >>

I am wondering if the following scenario is possible in DTS Task 1 Succeed go to task 2 Fail go to task 3 Task 2 Succeed go to task 4 Task 3 Succeed go to task 4 The problem I have is with task 4 I have 2 precedence constraints (task 2 and task 3) when only one of them is going to...more >>

Is it possible to use DTS to extract data from an Analysis Services Cube and to put the resultant data into a fact table in another star schema....more >>

I am executing a dts package from .net. I pass a global variable to the dts package and it executes a stored proc and then exports to a text file. When populating the global variable from within the dts package and executing it, the package executes successfully. But when I try to execute it fr...more >>

Can someone help with a code that will automatically re-execute a failed package.., try to re-execute it three (3)times, then exit if failed after the third time. Thanks -- Message posted via http://www.sqlmonster.com...more >>

I have a main DTS package (call this "Package A") that calls another DTS package (call this "Package B"). Package "B" does many things but one of the last steps it uses SP_RENAME to rename some tables. Package "B" runs just fine on its own. However, when called from Package "A", Package "A" r...more >>

Is there a way to do the following in a dts package? Using the pubs db - INSERT INTO db1.dbo.authors (au_id, au_fname, au_lname, city, state, zip, phone, contract) SELECT au_id, @FIRSTNAME, @LASTNAME, city, state, zip, phone, contract) FROM db2.dbo.authors Where @FIRSTN...more >>

I am fairly new to using DTS packages and I have Package logs enabled in my DTS package which has a lot of "Execute SQL Tasks". When one of these tasks fail it shows up in the error log, but the step name would as generic as "DTSStep_ExecuteSQLTask_23" and sometimes its difficult for me to tra...more >>

We would like to assign owner and user passwords to all of our existing DTS packages, short of having to open each package and Save As a new package, which will cause a new package ID to be assigned to the package. Is there a script that would allow us to insert password into the existing pac...more >>

I'm looking for advice as I've got to read a million+ rows from some tables on one server, transform and merge some of the data and write it out to a data warehouse on another server. The servers are on the same network. I was planning to create a scipt with one server as the source and the o...more >>

Hello Gurus Here is a simple one We are running several dts packages across several servers I was told that running the dts packages under the term run by trusted user may solve a permission problem we are having. I do not remember how to change to run by trusted user.... There is a switch...more >>

Hallo, I have the following problem: Currently I’m trying to „clone“ a running SQL Server 7.0 which is running under Windows NT 4.0. This means that I have another Windows NT 4.0 maschine with SQL Server 7.0 running on it. Now I want to copy all the data from server1 to server2. I di...more >>

I am executing a DTS package from vb.net. This package executes a stored proc which is supposed to return a return value. Here is my .net code: Code: [code] Dim oPkg As DTS.Package2 Dim oStep As DTS.Step2 Dim results As Boolean results = True oPkg = New D...more >>

Hi, Is is possible to pass parameters to dts package, that we need to run using dtsrun. I have a query like - select a,b,c from table where id in ('x','y'). We need to parameterise the 'in' CLAUSE. What is there in the 'in' CLAUSE can be more than I have given and it frequently changes. Cou...more >>

Hi, In a project I work on we provide various exports to our users via DTS packages that are called using a stored procedure. Recently a new package was added that does nothing but run 27 of the other packages one after the other. This works fine on test servers and for several of the...more >>

How would I execute DTS package in the SP? Thank you. ...more >>

Hi I am using yukon April CTP. I have a excel source. Every row from excel has to go to one master table and one detail table. I want to know how to insert a row to master table, get the scope_identity and then insert to detail table using SSIS. Note: Currently sending the row from ...more >>

How do I clear from Extended Properties the connections previously deleted? In a DTS with some SQL connections, if after saved you erase one of them is just erased from the design sheet but it remains in the DTS' Extended Properties. SQL Server 2000 Standard Ed SP 4.0, Win200 SP 5.0 Tha...more >>

Trying to use Python 2.4.1 with the Win32 extensions (build 204) inside of an ActiveX task. When I step through the package running each step, the package runs fine, even to the point of running the "message box" to see where the code is stopping. When I try to execute the package as a whole,...more >>

Is there a way that I can get the result of multiple select statements into 1 file from a DTS package ? Thanks for any help....more >>

I have 2 Windows 2003 standard edition servers: -Webbserver -SQL server (MS sql server 2000). Now I need to take some rows from the database and make a text-file. It works perfect, but the text-file is on the sql server. I want it to be on the webb server so people can download it thru HT...more >>

So here's my dilemma. I need an automated SQL Server (2000) job that runs once once per hour. This jobs should: 1) Retrieve unread email for the user "Le" from our Exchange Server, and insert it into a table. 2) Retrieve unread email for the user "Smith", from from our Exchange Server,...more >>

Hi, I might work on a DB2 to SQL Server data migration using DTS. What should I keep in mind to optimize performance? Thank you...more >>

Greetings. I have a job that transfers all objects between 2 SQL server 2000 SP3 without problems for several months and tonight it failed this the portion of error log generated: DTSRun OnProgress: Copy SQL Server Objects; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0...more >>

i want to import a data from a view from database by DTS how can i check that if the view is empty then i don't run rest of DTS . thanks Nick ...more >>

Is it possible to create a DTS package to import from a file in LDIF format? I have managed to import a CSV or other delimited text file but wondered if it was possible to read an LDIF format file. Thanks...more >>

I save a package in a Structured Storage file. Then I opened the saved package with EM and tried to Save as . . into Sql Server. This failed with "DTS Package 'Test package' already exists with a different ID in this category." I have no idea what that means. And there is no 'Test package' ...more >>

Hello All, I need to execute a child package from a parent package and I need to get the value of a global variable back from the sub package. The sub package may modify the value of the global variable at runtime and I need to get the modified value back after completion of the sub package. I...more >>

I have a DTS Package that imports to SQL Serer (2K sp3) from older dBase files. The package works fine if executed manually. When executed via SQL Server Agent (runs under domain account) - I get a series of errors: DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) E...more >>

How to build a DTS Package so it will generated excel file without column headers? Any help is appreciated. John ...more >>

Hello, I use DTS to transfer some tables approximately around 20million rows from as400 to SQL. Once I transfer 20million rows, the next time I only need to transfer updated data in AS400 not all the rows again. DTS wizard only has drop table in SQL then copy the same table from as400 to ...more >>

Hi All, There are 20 Databases on my server. Each one has same structure, but for dfferent companies. I have a DTS which transfers data from Source server [erp] to another server and then the same data to text files. Presently it's on development and will be shifted to live server. It's o...more >>

Is there any way to prevent the lost in phone format (000)000-0000 and fax format (000)000-0000 when transferring data using DTS between tables? The data we have is inconsistent, so we really don't want to lose the formats if possible....more >>

Hello all, I am trying to export the contents of a table in a database to a .csv file. At this point I wish to export the entire table. Using the DTS wizard I was able to find an option for a flat file. This was not sufficient for our development group however as they require a .csv file...more >>

This is a bizarre one. I've added a new ActiveX task using Python (I know, but I know it better than VBScript). When I step through the package, I have no issues. The task does exactly what I want it to. However, when I click Package - Execute, the package hangs @ that step. It almost seem...more >>

I am trying to call a lookup from my ActiveX script [SQL Server 2000]. Ideally, I want to call a SQL function I wrote and supply parameters for each row I am importing from a CSV file to retrieve a custom value that will be used in my script. However, it looks like the only way I can do this is...more >>