Hi I have a stored procedure which runs for one and a half hours when executed from sql server agent job. The same stored procedure runs for 10 minutes as a dts package that gets run from sql server agent job. This is in development. Now in test I cannot get the dts package step to run as it k...more >>

Hi all Having a bit of a hassle here with DTS on SQL2k, and was hoping someone could shed some light. Just to note, I had the same problem when using DTS on 2005 (SSIS), so it probably isn't DTS that's giving the problem. I have a "Microsoft OLE DB Provider for SQL Server" connection and a ...more >>

I have a DTS package which has 4 data transform tasks. Since they are not connected one another, when the package is run how exactly they will run? All the 4 will get launched simultaneously when the job is launched by scheduler? SQL Server 2K. Carl ...more >>

Hi: I am pumping data from an ODBC connection to Sybase to a regular OLEDB connection to the local SQL Server using DTS. I am trying to use the following code in the Transform Data Task: SELECT * FROM dTable WHERE Timestamp > ? I when I click on the "parameters" button in the Transform da...more >>

We have a DTS package that loads 46 text files from an FTP server into the database on a database server at 6:00 AM. every morning. The files are sent to FTP server at a various times. Even though the DTS Package is scheduled to run at 6:00 AM, is there a way of loading the data into the d...more >>

hi all i have got a problem in DTS. when ever i try to import an empty text file to sql server, it should automatically generate a message that the file is empty. i am trying hard to find the solution. can any one please help me out. ***************************************************************...more >>

I'm pumping a csv file into a table using datapump .I'd like to do some validation on every single field on each record while I'm transferring records and for that reason I need to retrieve a value from database based on the first two fields in CSV file.I noticed that I don't have access to ...more >>

I don't know if this has been documented anywhere, but it's news to me. We were having problems attempting to import a Unicode, tab-delimited, flat-file into SqlServer 2000 using a DTS package. One of the things we found is that DTS will only import a Unicode (UTF-16) file if the field-data...more >>

When importing a text file through dts data pump task, is the file read top to bottom, and inserted top to bottom, or can SQL Server cache the records and insert them in any order? I've checked and it seems that they are indeed inserted in the order they are read from a text file, but I wan...more >>

Hi I am using BizTalk Server 2004. My application uses the BAM feature too. I have to archive some of the data in the BAMPrimaryImport. As per MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/operations/htm/ebiz_ops_bam_admin_rgbi.asp, I used the BAM_DM_<activityname> ...more >>

Hi I have 3 execute statements in "Execute SQL Task" which accepts the same input parameter (i.e package Gloabal variable) exec InsertTestDTS @Status = ?; exec InsertTestDTS @Status = ?; exec InsertTestDTS @Status = ?; Currently i have to pass in 3 parameters to the above statements in ...more >>

Hello, How can I return customized error string for the scheduler/manually excuting to write to log/double click show error? For example '********************************************************************** ' Visual Basic ActiveX Script '**********************************************...more >>

I have ascheduled job that kicks off at 7:00am every morning, and i know the job runs but i don't see anything in the job history. The status of the job is 'performing complete action' , last run status indicates it completed successfully. The first two times it ran it did put something...more >>

Hi everyone, I am copying a database from one machine to another. The DB permissions are set for local users on each machine (including IUSER_WEBSERVER1 and IUSER_WEBSERVER2 etc). While copying the database I am using copy SQL Server Objects Task. Under Copy Tab, I am selecting create ...more >>

I'm using a simple DTS package to import large text files (600-900MB/25MM-30MM rows) into a database. The database has plenty of space for these files, but when I import a file, it starts off very slow (about 1k rows/5 seconds) and gradually speeds up until the row count flies by at speeds ...more >>

I created a DTS package that copies a file from one network directory to another. When I execute the package manually it works fine, but when I run it in a job I get this error: Executed as user: YMSSERVER1\SYSTEM. ...art: DTSStep_DTSFTPTask_1 DTSRun OnProgress: DTSStep_DTSFTPTask_1; Cop...more >>

Hi, I have a question about running DTS from VB. The DTS just simply export data from table to TXT file. Is there any way how to show in VB progress of execution. The DTS runs very long. thanks Jakub...more >>

Hey all I have a SQL Server 2005 DTS package that moves data from one table to another. OLE DB Source (SQL Server 2000 DB) to OLE DB Destination (SQL Server 2000 DB), with a derived field between. Nothing fancy. Been working whole day, and now I am getting : "[<DataFlowItem>] Error : Acqu...more >>

I'm trying to use DTS to transfer data from a local SQL Database up to a remote SQL Database. I get the following error. I'm trying to replace the data. Both database are named the same, tables the same and the table structures are exactly the same. Locally, the owner is 'dbo'. Remotely, the ...more >>

Hi, I am using a stored proc which takes three input parameters based on which it would identify the table, and fetch the rowcount of the table before delete and execute a delete command on some condition and perform again a rowcount The SP returns two output parameters of type int. c...more >>

I am trying to set up a webservice in SQLXML 4.0 in Yukon Beta 2. I am then trying to consume that service via a Web Service Task in SSIS (SQL Server 2005 DTS) but getting an error stating "WSDL not supported". Anyone have any experience with Web Services Task via 2005? thanks Joe...more >>

I'd like to pass two date variables from a VB app to a "Transform Data Task" in my DTS package. This seems to be an easy request, but I can't find any documentation for it. Does anyone have any snippets or docs? Thanks. *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hello, I would like to know if it is possible to run a DTS package from a VB app on a remote workstation that is on the same network as a Sql Server machine but does not have sql server loaded on this remote workstation. I have a VB app that can run a DTS package without any problems if ...more >>

How can I define a working connection to a secured excel document within DTS. Where and how can I provide the excel password to access the secured document as a data source (named data ranges within the document) Regards, Adri...more >>

Hi all! I have created a dts package with SQL 2000 SP3a hotfix 818. I saved it as bas file and imported in my VB.NET service; I then fixed = the small issues remaining with VB6->VB.NET translations. The service compile file and works for a while than crashes without = notice. The debugger sa...more >>

I have 2 packages called "A" and "B". Package "A" is schadulaed to be executed every 10 minutes and it is supoosed to call Package "B".In package "B" I call an Stored procedure called "Bsp". Here are my questions: 1) Say that calling package "B" and it is running,10 minues is passes and ...more >>

hi all, I'd like to set the Win32 process task ,dynamically in my Activex task .Is there a way of doing so? Thanks ...more >>

Any idea how I can stop a query from timing out? I am running a simple but long query on a remote Progress table using DTS, in order to pull data into a SQL Server Datamart, using a datapump transformation task in my script. However, to limit the amount loaded, I am trying to retrieve maxim...more >>

Hi: I am fairly familiar with SQL Server and DTS but not programming code-I am doing research for a programmer. I imagine what we want to do is fairly common so if if there are any articles out there you know of that would be helpful: 1. We need some idea as to how to do the following throu...more >>

Hi, Any idea how can I set the destination file property of the in pre source stage, in multiphase data pump using ActiveX Script? Thanks and Regards, Karunakaran ...more >>

Do you know of any way to identify all the objects, including child objects, that a DTS package uses? ...more >>

I have an Excel 2003 spreadsheet that includes a column of times (e.g. 9:08 AM, 10:15 PM, etc). I want to import that into a SQL Server table. I tried using a transformation with CDATE but the import still blows up trying to import that time field - Is there a way to do this? TIA Wayne ...more >>

Hello all, This is really driving me crazy, any help will be appreciated. We have a Windows 2003 Server (no SP1) with VB6 COM+ components installed on it. We have a Windows 2003 Server (no SP1) with MSSQL 2000SP3a on the other side. No firewall between the two of any kind and both sit ...more >>

Problem: I need to know the affected rows by the bulk insert task. In my DTS package I tried to have the ActiveX Script or Exec SQL task to fetch the rowcount after insertion. But in my scenario there would be simultaneous packages running sometimes against the same table. Due to which I ...more >>

Hi, I have a created A DTS package using the import wizard, and I selected the radio button so it delete's rows from the destination tbale. I want to modify this so it only delete's rows if there are rows in the source table (prob using an EXISTS clause) But there is no where in the DTS des...more >>