I'm exporting data to a csv file which needs to include some fields that I dont have in my source table. Some of these will have no value but must still be included in the csv file one will have a static value for all records and one will contain a static URL ending in a querystring value ...more >>

I have a file that I need to download via ftp. Every time I need an update the file on the server has a new name. The file is named with a date (filename040114). Is there a way to ftp the entire folder contents with the FTP task? I considered using an INI file with a Dynamic Property Task, ...more >>

Hi All, Is there a way to tell DTS to log an error, or to call a stored procedure that logs the error, to a SQL table in SOURCE and/or DESTINATION database? Thanks. ...more >>

Hi: I created a DTS package that imports the Master Database from one SQL server to another for emergency's and it works fine except the passwords don't seem to come over. Is that a limitation or have I not configured the package correctly? ...more >>

Microsoft SQL 2000 Windows 2000 Server Puzzling occurance. One of our DTS packages transfers data from the AS/400 to an Oracle server. In our test enviroment, data is appended to the Oracle table and whenever the record count gets beyond 2 million, DTS doesn't transfer any data over. ...more >>

I have a dot net application in c# which invokes a stored procedure. The stored procedure invokes a DTS package . DTS package take a text file and transfer data to sql server table This part fails roughly 3 times in 100 attempt. I am not able to find out why exactly it is happening. When I web ...more >>

I have a udl file for an DB2 database that seems to work when testing it via de GUI. Zehn i use it in DTS to import data however I see no tables, views or any other objects at all. The test account has "sa" level permissions in the DB database> Does anyone have any ideas or tipss? Thx ...more >>

I have a DTS package that kicks off another one, looping through a recordset. I have Dbase 3 connections in the child package, and am trying to reset the path to a new path with each loop. I've tried using the dynamic properties to set the datasource = dtsglobalvariable("dbpath") I have a me...more >>

While running a copy of the production database for a new machine. I get a CDW error. Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000) Step Error Description:[Microsoft][ODBC SQL Server Driver] [SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQ...more >>

I get a DTS Designer Error (The system cannot find the file specified) whenever I open DTS Designer to create or edit a package, and the task toolbar/box is empty. Appears as though some .dll is missing or unregistered. It was working fine, but not now. Anyone experienced this and know ...more >>

I have a simple package which transforms data from an excel spreadsheet into a table in my SqlServer 2000 database. The package contains two connections, a dynamic properties task, and a data transform task. I have setup the workflow so that the dynamic properties task finishes execution before...more >>

Hey All, I have seen this question a lot but i still don't understan how i do it. I have a sp that needs to call a dts package and pass it a variable. So far i have my sp below that reads as follows. DECLARE camp_cur CURSOR FOR SELECT campaignID FROM CampaignCodes FOR READ ONLY OPEN...more >>

is it possible to execute into a table. i.e store the output of the code below into a table DECLARE tables_cursor CURSOR FOR SELECT distinct tbname FROM maxsyscolumns OPEN tables_cursor DECLARE @tablename varchar(30) FETCH NEXT FROM tables_cursor INTO @tablename WHILE (@@fetch_status <> -1)...more >>

Is it possible for DTS to read/write to files in a shared folder ? If so, any examples out there ? Thanks Dave ...more >>

Hello, Is it possible to have within a DTS package a task that would open a Text file using KEDIT or any other text editor then save the text file. After file is saved, the text file will be copied (column to column) into a SQL server table. any ideas will be highly appreciated t...more >>

Hi, I need some help to solve this problem. I have been running this DTS package on a scheduled daily batch job on SQL 7 Agent to pull data from an Oracle server. It has been runnning fine since May 2003. Lately in December, some tasks in the packages start to fail every day until today...more >>

Hey all, Is there a way to determine that a package is currently executing? I have a job that executes a package every four hours and would like to be able to check on subsequent executions whether the package is already executing, in order not to execute again. Regards, Kevin...more >>

Hello, Is it possible to have within a DTS package a task that would open a Text file using KEDIT or any other text editor then save the text file. After file is saved, the text file will be copied (column to column) into a SQL server table. any ideas will be highly appreciated t...more >>

Hello, Do we have to wait for Yukon before we can use "managed code" with DTS? Attila...more >>

Is it possible to do a DTS across domains? I have an old NT domain where a SQL7 server is running a huge database. I have now, in our Active Directory 2003 domain, a 2003 server running SQL2000. I need the old data in the new database. If I go to DTS wizard, I don't see anyway of gettin...more >>

Get error when 'dtsrun' is run on client machine. Error: [dbnetlib][ConnectionOpen(Connect()). SQL Server does not exist or access denied. 'Access denied' - no authorization outside the server. What kind of security authorization is necessary? Thanks, Jim *************************...more >>

Hi, I'd like to use a result of dbcc checkDB of a server A in a DTS package of a server B. I want to store the result in a txt file. How to create this package ? (i'm beginner in DTS)...more >>

Hi, Here is my problem. I have created some stored procedure. In them I do some print in order to know what the stored proc does. Now I execute my sp with DTS. How can I get these 'print' in DTS? I is quite important for me for debugging matter. Thanks a lot Lydie...more >>

Get error when 'dtsrun' is run on client machine. Error: [ConnectionOpen(Connect()). SQL Server does not exist of access denied. 'Access denied' - no authorization outside the server. What kind of security authorization is necessary? Thanks, Jim ******************************** S...more >>

Hi, I'm running a DTS from a scheduled job and it's taking ages. The DTS transfers data between 2 tables and I would like to see how far the DTS has gone -use fast load is enabled-. I can see from running sp_who2 that data is being inserted into the destination table via a bulk insert, which make...more >>

When I try to open a DTS package through a client machine or try to create a new DTS package, the screen is blank. It's not stuck as I first assumed but it does not load the package in DTS designer view. Does anyone have any suggestions? ...more >>

Hi All, I am trying to load a text file into sql server table using DTS package saved as vb module.This executes fine for the first time when it is created , but any attempt to run again hangs the system. any clues why it is happening so? I am using sql server 8.0 and vb 6.0. Same pa...more >>

Is it possible creating a DTS package that in case of error, the record is logged and the package continue to run? Thanks IS...more >>

I am running a DTS package on Oracle using microsoft Oracle ODBC Driver. Both the source and destination are Oracle tables The source has about 150000 rows. When the transformation is a column to column I get the complete transformation of 150000 rows. When I introduce active X scripts only 13000 r...more >>

We are using MSDTC to perform distributed transactions between our application server (A) and a database server (B). Application server is running windows 2000 with IIS 5 while database server is running winnt 4 SP6 with SQL 7.0 SP3. These severs are separated by a firewall, but no NAT....more >>

Dears,[ Is it possible to make replication of objects. For example: I have two servers (S1 and S2). Evertime I change a procedure on S1 I want to alter the same procedure on S2. I think I have to make a synchronization between the master databases of the servers, but I don´t know if i...more >>

How can I referance a task by name instead of by its Task #? This works: Set oPkg = DTSGlobalVariables.Parent Set oStep = oPkg.Steps("DTSStep_DTSActiveScriptTask_3") Need it to be like this: Set oPkg = DTSGlobalVariables.Parent Set oStep = oPkg.Steps("MyTaskName") -- ____________...more >>

We are migrating from Oracle to SQL Server. I'm attempting to create the DTS packages we'll need to migrate the data. We will have already created the tables on SQL Server so we'll just be copying data. Our plan is to copy the data twice. Once for testing and to use as we convert our apps, ...more >>

I was a bonehead and uninstalled MSDE 2000 which had a fairly elaborate DTS Package. Not realizing what had happened, I proceded to reinstall MSDE 2000 and then of course noticed the package was gone. Does SQL Server save a package anywhere on the hard drive that is recoverable? MSDE ...more >>

I'm sure this will have already been asked on this forum but to save some searching.... My hosting company (fasthosts) does not allow database backups using the standard Management> Backup. Instead, they say use DTS to backup. Has anyone any idea on how this is done, as I have never used DTS be...more >>

I've created a simple DTS package that exports data from SQL server into a CSV file... so far so good. However, I want a non-technical user to be able to kick this process off. Is there way they can do this without having to go into enterprise mgr? Thanks Chris ...more >>

Please help I am trying to return the number of records in tables in our database using the script below. The problem is, I can not format the EXEC() to return the table names and some text. such as 'The number of rows in TABLENAME X '=' Y DECLARE tables_cursor CURSOR FOR S...more >>

Is there a way to use Bulk Insert to skip rows that have errors? For instance, if I have a text file I want imported, if it encounters an error (say the number of fields are incorrect for that row), is there a way to skip that row and continue the import? How? ...more >>

Can someone assist in a code snippet showing how I can manipulate a Parent DTS package from a child DTS package. Example: DTSPack1 calls DTSPack2. I want DTSPack2 to be able to change some of the connection properties in DTSPack1 - so that when it returns to DTSPack1 it will continue running...more >>

Hi, Can anyone help me. I have a whole bunch of DTS's that I would like to execute using one scheduled DTS. All I need the DTS to do is execute each DTS and on completion execute the next one. If I run the DTS's individually they run fine and fast, but as soon as I execute them within the DTS pac...more >>

I have a DTS package that is called by a scheduled job. The dts package calls a stored proc. I've noticed that when i amend the stored proc, the next time the job is due to run it fails. If i recreate the package then schedule all is well. Obviously a pain in the bum while i'm testing ... ...more >>

I know how to pass values in as parameters to a stored procedure and receive the resulting recordset using global variables. What I need to capture is the return code from the stored procedure as that's where our error codes are kept. How do you capture a "return" statement's value in a stored p...more >>

I am new to DTS world. Can anybody tell me what are the various ways a dts package can be executed. Thanks a lot. ...more >>

Is it possible to execute a DTS package from a sproc or a trigger without using sp_start_job? If so, how? I can't use sp_start_job since I'm not the admin. Thanks for any help. Mary ...more >>

I am trying to insert large text data into a field with ntext data type definition, i cannot insert more than 255 characters even after using the sp_tableoption table, 'text in row', 7000 , kindly suggest how it is possible to store complete html of yahoo.com first page into a field. i am using s...more >>

Using code examples from sqldts.com, I'm trying to use the same datapump task to import data from multiple source databases, ito a single db. All of this occurs on the same server. The code snippet below will loop thru once for each entry in the companyinfo table, and the connection object ...more >>

I have experiencing an issue where I am using a Dynamic Properties Task to set the Data Source of an Excel output file in a SQL Server DTS package. The Dynamic Properties Task uses a query to return the value and looks like this: select 'E:\Reports\Accounting\Daily\SalesReport_' + CONVERT(v...more >>

After importing several rows to a table, I need to fire a SQL statement to update 2 columns from a single column. My full name column needs to be broken out to Fname and Lname columns. I have this query that works well in Access but I need the SQL equivelent for it. Help apprecaited. Thanks. U...more >>

Is there any way (wizard or otherwise) to override this? I changed the table fields in the wizard by selecting create table and increasing their size, but then I get a buffer exceeded warning. Is there a way to do this so the data is not truncated? (field size doesn't exceed 1500, three fields in...more >>

Hi, Has anybody any idea about what that @"$**"' error means ? (sorry it's in french but the error is -2147220482 (800403FE) error, provider error) Thanks Exécuté en tant qu'utilisateur : XXXX\SYSTEM. DTSRun : en chargement... DTSRun : en exécution... DTSRun OnStart: DTSStep_DTSActiveScrip...more >>

I have a DTS package that has a scheduled job. It has been running fine for over 2 years now from a scheduled job. The scheduled job will not run now. I can execute the package on its own in Enterprise Manager, but now the scheduled job creates this error DTSRun: Loading... DTSRun: Executin...more >>

Hi, I am using SQL Server 8.0, and am using an ActiveX script. I have a source that for every row in that table, I need to put two rows in the destination. Is there a command that allows me to add a new row in the middle of the ActiveX script. So, I would have code to make one row, a...more >>

I wrote a simple vb.net program to identify and track the number and size of backup files for the default instance of SQL Server 2000 SP3 instance on a Windows 2000 Server. This program is set up to run in a dts package. When a job that executes the dts package runs, the vb.net program does...more >>

Hi Al I have built a DTS Package that updates some SQL Tables and then Processes an Analysis server Cube. I want to execute this from a client PC under the control of VB. I have built the VB program using the LoadFromSQLServer method and it works great from my PC . When I installed it on the cl...more >>

Hi, I have a DTS that I am writing in SQL Server 8.0. This is what I have: I am writing an Active X Script Transformation. I want to create from my source table, two columns in my destination table. I want to be able to have the DTS run through the first part of my code, and then te...more >>

I previously had a dynamic properties (which sets a filename for import in next step) linked to a file import with an on success workflow. Now when I try to link them together with an on success, I get the above message "defining precendences between the selected items is invalid". Any...more >>

Hello everybody I have DTS package that bulk inserts text file into the SQL server 7 table. The DTS package is called by the job and job is scheduled to run every morning (it worked fine for almost 2 years) Yesterday out of nowhere the job failed. I got the error message Error = -2147217...more >>

Hey, I am renaming a table that is referenced in over 100 DTS packages. Is there any (faster) way to do this other than one DTS package at a time? Thanks very much. Mark Palfrey...more >>

I have a 50MB text file that has about 150,000 records in it. Each field is ended with a "|". I ran this command: BULK INSERT db.myfile FROM 'C:\textfile.txt' WITH ( FIELDTERMINATOR = '|', ROWTERMINATOR = '\n' ) I received this error: Server: Msg 4863, Level 16, State 1, Lin...more >>

Hello There! I have been trying to parse a TXT file so it is ready to be used in a DTS package, basically to be copied into a table. I basically need to do the following: 1. Delete first two lines 2. change last column name to Cur Cod2 3. Then save the text file so it is saved with correc...more >>

How can i automate microsoft OLAP cube processing with dts...more >>

I am hoping someone can explain the design intention, that I might be better equipped to deal with this. We are cooperating with another company, far away, to develop DTS packages over long term. We do not (yet) have a way to network with them, so we hoped to save to Structure Storage Files, a...more >>

Hi I do a transformation form access to SQL server. for a field i do a lookup and i want to store the result also in another table. How can i do that in the transformation script? Peter...more >>

I am running SQL 7.0 Desktop server on Win2k Prof. When I use DTS to import data from another sql server, it says License does not permit DTS function. Can anyone say how to get it to work? Thanks, Murali...more >>

we've now encountered on two client sites, both using SQL2K Enterprise, that dtspackages 'fail' with no error logs, windows event logs or DTS logs generated (DTS log for pkg shows a start but no end entry). All servers loaded with Sp3. Interestingly, on one site that has Standard and Ent edit...more >>

SQL 2000 SP3 standard on Windows 2000 Adv server. Package is used to transfer data from Oracle. It could run manually but failed when scheduled. Here is the log: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExe...more >>

I have an app that was using Access that I'm converting to Sql Server. In the office a replica was created on the users local drive and would sync with the design master on the network, when the users went off-site the app would create a replica to a laptop which became a "server" that th...more >>