I have several DTS packages scheduled as jobs in SQL Server Agent. All the DTS packages execute flawlessly when run manually. When run through the job subsystem, the DTS packages execute, but packages in which the final step is to FTP the results to another server will hang on that final step....more >>

I'm trying to use DTS to upload data via a query statement. The PK is an identity column. I tried running the query without saying anything about the PK, thinking it would supply those values (like MS Access does for me) but it failed because those were left null. What should I do to import my...more >>

Does anyone know how can I use DTS global variables in DTS SQL statement? Thanks a lot. ...more >>

I received from DTS File and related Excel Sheet from my customer. I could be able to open the DTS File. It showd a connection between Excel and OLE DB Data Sources. Then I treied to run this , it says ' Trasform Data Task:Undefined ' Kindly let me know the procedure to run Am totallay ...more >>

I'm trying to pull files from an ftp site. Part of the file name is the current date. I have put together an Active X script task to generate the file name, but cannot get the dynamic properties task to use the generated file name. I read that following the file name with 3 semi-colons (;;;...more >>

Hi, I've been trying to get bulk insert to work and have this statement bulk insert dbo.myTable from 'c:\test.csv' with (datafiletype='char', FIELDTERMINATOR = ',',ROWTERMINATOR = '\n') I'm trying to get this to work in the SQL query analyzer. But i see that it is trying to find this file ...more >>

The script is exactly the same, but doesn't work as part of a DTS package. -- ************** -- ************** SETUP TEMP TABLES -- ************** declare @logsize real declare @logspaceused real if exists (select * from tempdb..sysobjects where id = object_id(N'[tempdb]..[#tmp_sfs]')) ...more >>

Is it possible to execute a cursor in DTS package? HOW? Thanks in advance!! ...more >>

I have set up a loop in DTS which connects to various servers and collects data from them. I have two parameters which are fed into my transform data task query from global variables. EXECUTE uspGetAlertPool @LastRun=?,@ServerID=? For some reason, the LastRun is not updated every time it l...more >>

I'm using SQL DTS to import data from files with dynamic names into a SQL table but I'm stuck at STEP 7 of the batch file.(as in the link) http://www.databasejournal.com/features/mssql/article.php/10894_3325731_1 I'm saving my DTS package as a Structured Storage File. I'm able to capture t...more >>

Does anyone know if there is max number of records DTS will import into a table. I'm getting an error saying there are too many delimeters in a record but that record looks fine to me. I'm wondering if this error is just a generic one and really means something else?? Thanks!...more >>

I'm fairly new to DTS. I'm running a Dts where the source and the destination are Oracle databases. I need to run some Sql statements to create temporary tables and proper indexes before doing any more complex stuff. When trying to run those statements in an Sql Task, it seems that i'm only ab...more >>

I having problems with the following scenario. (1) When I run a DTS package that processes a cube it works fine. (2) When however I run this package from within another package it just hangs, i.e. starts but nothing happens. Both packages run under the same Windows authorisation which is ...more >>

Hello, I'm trying to import a text file with fixed width fields. I've noticed the following problem regarding this: Let's say I have four fields in my text file. When field4 is blank, i.e. there is a {CR}{LF} after field3 the import process does not mark field4 as null. Instead it goes to the...more >>

Wonder if there is any way that I can put up my microsoft files into the website? And have it design as whenever I save the latest edited files it will be captured on the specific website as well?...more >>

Hi Friends, I have a SQLServer Job that try to execute a command DTSrun using the proc xp_cmdshell, but I receive "Access Denied" when the DTSrun are executed my configuration: SQL Server 7.00 - 7.00.1063 (Intel X86) - SP4 Windows 2000 - Service Pack 4 Someone can help me ? thx Jo...more >>

How to populate a global variable by reading the data from a database. Basically I want to find out the max date from a field and poulate the variable. SQL2K. Thanks Brian ...more >>

Hi all I have a Windows Server 2003 Web Edition running. No i have one problem...I can't install the Enterprise Manager on the Web Edition of Windows Server 2003. How can i still get a DTS running on a SQL 2000 MSDE Version? how can i copy it or move it over to that machine? thanks for y...more >>

I have a DTS Job that is scheduled to run daily on our SQL Server 2000 server. Is there an easy way for me to determine if the DTS job ran successfully? Does DTS provide anything for this or must I use DMO to look at the jobs collection? ...more >>

Hello all! I've created a custom DTS task in the .NET Framework 1.1 and have it installed and partially working on the server it will be residing on. If I log into the machine using my account and manually open and run the package, everything works. If I log in and use the limited SQL Ser...more >>

I run several DTS packages each day, I would like to convert from an e-mail based export system where I save the exported file locally to the server, then pick it up as an attachment and email it to a system where I export the data file to a network share location. The issue I am having is ...more >>

Hello All I want to create a export of a given table as a .xml file with a .xsd Can somebody please point me in the right direction how I can do it. Also, once I have created a .xml and .xsd how do I import the table structure and contents after having dropped the table to recreate it fro...more >>