Hello, I am trying to import a comma delimited text file with double quotes as the text qualifier. The DTS is scheduled daily. I don't control the source file contents. The latest file included a field with another set of double quotes in the field. When the dts runs I get an error, In...more >>

Hello, I have created a real quick DTS package from the import wizard. It is an ugly package not very optimized, but it works for what I need. The problem is I had to go in and make some manual changes, I made those changes and it took some time (over 250 tables, change needed in each transfo...more >>

Hi, Today, I tried to create a SSIS Project using Visual Studio 2005, but = there is an error occus, here is information: Failed to save package file "C:\Documents and Settings\owen\Local = Settings\Temp\tmp1ed.tmp" with error ox80040155 "Interface not registered". I searched on ...more >>

Is it possible to process Analysis Servies 2005 cubes from Analysis Services? We are currently moving our existing 2000 cubes over, but there are a number of DTS packages that we would like to be able to continue to use until we can move those to SSIS but one of the things DTS does is proce...more >>

Hi, Could someone explain me the difference between calling the execute method of a DTSStep_DTSActiveScriptTask and setting its execution status to DTSStepExecStat_Waiting? Thanks --Ilann ...more >>

Hi I'm trying to set up a Reporting Services report which consumes data from a SSIS package. I have a really simple package which just one data flow task. This task "transfers" a few records from an OLEDB connection to a DataReader Destination. When I try to consume these data in the...more >>

Good Morning all I am a bit new to the sql world. I am using a dts package to copy a db from our production server to our backup server. I followed the instructions I found on this site to the letter https://help.maximumasp.com/SmarterTicket/Customer/KBArticle.aspx?articleid=659 1. log on v...more >>

Deos anyone know how I access a Data Flow DataReader Destination from within a subsequent Control Flow scripting step?...more >>

Hi, Is there a way to create a duplicate DTS packages, I would like to create an exact same package, then modify it a bit, because some of my data wasn't process. I am trying to get the data out of my HIST file and then re-run the job again. Many thanks, Steve...more >>

I'm trying to fix some errors in a SSIS package that occured after migrating from a SQL 2000 DTS package. I've been fairly successful so far, but I'm failing miserably on a data conversion. How can I convert a string formatted as Jan 11 2006 12:00:00:000AM to a smalldatetime? Any help ...more >>

We have a SSIS package that intermittently fails on the deployed server (works fine on our dev server) with the following error: "The variable "%1!s!" is already on the read list. A variable may only be added once to either the read lock list or the write lock list." Not only does it fail ...more >>

I want to tranfer data from 10 tables from server a to server 2. for this what is best approach and why ? 1. make seprate DTS for each table 2. make one DTS for each table ...more >>

Hi, I am creating one dts which access tables on my test db server. Now after test i want to copy that dts on to my prod server. In that case tables will be accesssed from prod server. Now problem is in transformation task i need to change all the table names as they come with db.tablename forma...more >>

Hi All, I have a DTS package which runs a stored proc, copies the result in an xls and mails the xls to me. The package runs fine when executed manually, but when it is scheduled as a job, it seems to hang. After some testing I found that it hangs at the 'Mail Sending' part. If the Send Mail t...more >>

I am new to DTS package design but want to do the following. I want the dts package to move several tables from an mssql 2000 dbase to an access file but it must first delete the tables in the access file. Also I want it to stop execution if any of the copies fail. I created a dts package t...more >>

I'm trying to get the return value from a stored procedure in a SSIS execute sql task. The SP is just a return 1 at the moment, and I can't figure out how to get that value and put it into a user variable. Any suggestions? ...more >>

While running DTS, happens randomally in different tasks. anyone?...more >>

Whats the best way to move all packages to another server? Ive got hundreds to move and the only thing I know is ...Open Packages..Click Package..Save As Thnks JL ...more >>

After installing the SQL Server 2000 DTS Designer Components necessary to edit legacy DTS packages using Management Studio, I get the following error when trying to edit DTS packages via 2005 MS: "The DTS host failed to load or save the package properly." What's worse, after I install the desig...more >>

I'm trying to import .pdf images into our database using an "Import Column" control. We have a directory of images for each county in the state. I'm loading the images from each directory with a separate run of my SSIS package. The 1st 2 sets of images, 3035 & 10314 .pdf images consecutive...more >>

I have created a simple SSIS package that downloads a file from and FTP site and inserts the data into a SQL Server DB table. I can get it to work if I hard code the filename, but once I use a variable I get the following error: Error at FTP Task: Failed to lock variable "<path and filename ...more >>

Hi If i need to connect to ssis server from sql management studio, what are the minimum permission i should have to connect the ssis server. i dont want to give admin access or sql admin access. Thanks inadvance....more >>

We have a DTS pulling data from Oracle via Link server. The connection between oracle and SQL seens not very good. Quite often, we will have following error: Step Error Source: Microsoft OLE DB Provider for SQL Server Step Error Description:OLE DB provider 'MSDAORA' reported an error. The ...more >>

Hi: I'm running DTS package where all steps are set to "join transaction if present" in the Workflow properties. The transaction isolation level in the package properties is set to "read committed". The distributed transaction service is on on the server. SQL Server service pack level is SP4....more >>

Hello, I am new to DTS. I currently use msft access to read several large text files with no delimeters. I use the schema.ini file and link the files as a table. Then I read them via vbascript into tables with the columns that I need, while having indexes on them for the speed of my vba...more >>

Hi, I am trying to optimize job for DB maintence to plan DB maintence plan1 I have to the following error "Executed as user: 123star\Admin. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed." please help. Many Thanks, Steve...more >>

I am getting the following two errors in the event log when trying to copy a database from SQL2000 to SQL2005. Any ideas? SQLServerAgentError SQL Server Scheduled Job 'CDW_GRAYMATTER_LENNY_1' (0xB5C7AFF09C96C146A1FE9B383370F008) - Status: Failed - Invoked on: 2006-01-10 15:54:46 - Message...more >>

I would like to extend the behavior of the Derived column data flow transform. How do I do that?...more >>

Can anyone please help me? I have big problem with my DTS, the job won't run anymore, is there a way to roll the job back sinc last succesful job, here is the message that I have got" Executed as user: 123Star\Admin. ...ing... DTSRun OnStart: Delete from Table [MMLive].[dbo].[temp_stock]...more >>

Hi, I've created quite a few DTS packages that open up VPN connections to remote SQL Servers, transfer data to local SQL Servers, writes audit records, then close the VPN connections. Everything has been working well. Saturday all of the packages (scheduled as jobs) began to fail. Friday...more >>

Hi All, I have a DTS package that copies flat files into my SQL 2000 DB. there are about 30 steps in this package. This job failed this morning, I have logging turned on and in the log file there is a failed step: Step 'DTSStep_DTSCreateProcessTask_1' failed Can anyone tell me of an eas...more >>

Hi, We have 2 sql 2000 servers PROD_1 PROD_2 all dts located in msdb on server PROD_2 all dts run from server PROD_1 using xp_cmshell dtsrun When I start dtsrun from PROD_1 it starts on server PROD1 but connects and execute package on PROD_2 dtsrun /S PROD_2 /N 'my_dts_on_prod2' I...more >>

We are using DTS Text File packages to import data into SQL Server tables. We have run into a problem with a particular file. This ~5000 lines file fails on parsing for no apparent reason. If we try to import the file directly using the DTS Wizard Text File Import, the preview screen hangs ...more >>

I have a several DTS packages that contains some tasks and other inner packages. Those DTS's are scheduling using the SQL Agent. Once in some days, one (of those DTS's) stops his run without any error messege. Of course the other steps after this step (that was "stuck") are not running as w...more >>

I have no problem importing data from AS400 (V5) to SQL Server using DTS. However, I am unable to do the same from another AS400 which is V3R2. I can get a connection & see the data files, but cannot get at the data. Any suggestions? ...more >>

Greetings Sql Server 2005 SSIS gurus! In migrating data into Sql Server from flat file sources I've found SSIS to be incredibly fast. i.e. 300,000 records + in less than a minute. However, now I need to extract some complex data out of Sql Server ... In an attempt to make things ...more >>

Anyone ever get this error when they tried to set a refernce to DTS in VB: 'Package' is ambiguous in the namespace 'DTS' I'm stumped. ...more >>

I am trying to save a SSIS package in SQL2005 to the database and it keeps failing. I am getting the message: Save to SQL Server Failed. No description found. I can save it to a file without any issues. Any help would be appreciated. ...more >>

I have saved my dts as a vb file, made changes and now I want to open it again using Enterprise Manager. How can I do this?...more >>

Hi All, Can anyone explain me. What do you mean by incremental transfer ? -- Regards Bharat Jariwala ...more >>

Hi All, How can we maintain transaction inSQL Job ? I create DTS package and SQL job of that package.what i wanted to do is when user stop SQL job during its run, Job should able to rollback all transation. -- Regards Bharat Jariwala ...more >>

I'm a complete newbie to SSIS -- I would like to "automate" the Copy Database Wizard (so that I don't have to enter the source/destination each time -- and so that I can also schedule the operation). Could someone provide some pointers on how to do this, either using SSIS? (Or, do you recom...more >>

What SQL Server permission(s) are required to both modify and execute DTS packages in SQL Server 2000 and SQL Server 2005? Thank you. -- Mike...more >>