We recently upgraded from SQL Server 2000 to SQL Server 2005 and have a DTS package. When I try to do anything with the package -- run it or import it -- I get a "Class Not Registered" error from "Microsoft Data Transformation Services (DTS) Package". Several posting suggest trying to registe...more >>

Hi, I am a newbie. I am trying to configure Dynamic Properties task in a DTS package. The DTS package is supposed to move data in 6 tables from one of the Production servers to the Test Server. The Production Servers can either be PROD1 or PROD2 that will be passed to the package during run...more >>

Hi: If I change the target database to a different SQL Server database (with exact same table names and structure), it doesn't change the database and I have to manually change all my transformations to point to the new database. Is there an easy way to change all the transformation destinati...more >>

I am using an SCD transform with a dimension table with 450,000 records. The SCD is really slow. Does anyone know anything I may be able to do to speed things up? Thanks for the help! Scott...more >>

Hello, I am calling a .Net Assembly (.DLL) from SSIS Script Task which is deployed to GAC. I need to debug the code in dll. How do I acheive this? Waht process do I attach the debugger to in order to enter debug mode from SSIS Script Task. Thanks, Sachin R. Chavan...more >>

I have a tab-delimited text file (.dat file) created via sql server that I'm attempting to parse in visual basic 6.0. I have tried Random, Sequential and Binary file access. All to no avail. Finally, I had to parse the file by retrieving the position of each tab in the file. That is, read a li...more >>

Hi When I try to convert from Prervasive V8 to SQL using an ODBC connection. I receive the error message.. ParseDisplayName failed: The specified module could not be found. Could anyone advise what this error is? And/Or how it could be resloved. This is happing when I press actualy...more >>

When I tried out a SSIS FuzzyLookup task, I experienced a problem as below: - Task: SSIS FuzzyLookup - source: SQL 2005 table - reference: another SQL 2005 table - column: last_name - problem at: FuzyyLook Transformation Editor dialog - problem when: after I ...more >>

I have a table which has an update trigger to keep the log's table. I need to do a bunk update and don't need to track the logs. How can I stop the trigger before running my SQL Task (DTS) and re-start the trigger when the task is completed? From http://www.developmentnow.com/g/103_2005_4_0_0_0/s...more >>

I have a SQL server backup from an unknown version. It is a *.bak file and I would like to restore the database. We run SQLServer 7.0. Could someone point me in the right direction about how to get started. I've run DTS Import but when I specify OLE DB provider, I do not seem to get an option ...more >>

I have a DTS that's dependant on 3 other DTS's completing successfully. How can I set this up so it will run only after those 3 have executed successfully? ...more >>

I am using MS SQL Server 2000 Standard Edition with SP3a. I have created a package to FTP some files from our Mainframe to a local directory on the same SQL Server box. I have scheduled the package to execute at a specific time everyday using the job scheduler in MS SQL Server. The job repo...more >>

I output 20+ columns to a raw file in one data flow step and read in 5 columns from that file in another (later) data flow step. My task is to add a 6th column that already exists in the file (and in the previous RFS definition). My problem is the Advanced Editor for RFS only shows the 5 colum...more >>

If I'm importing from a .CSV file into a table and it gets interrupted or fails to complete the import for any reason, is it possible to rollback any changes that occured so the table goes back to its original state? Thanks! ...more >>

Hello, I'm trying to write a vbscript that checks to see if a file exist before kicking-off a DTS import and I wanted to know the following: How can I have the script return a Successful or Failure execution? This will help me determine whether the rest of the DTS continue or stop immediate...more >>

have a dts which has 2 path's that come to the same "Sql Task". i dont know why but when i remove one of the arrow's with event like success/completion everything works great! but when i have 2 "event" that come to this "SQL TASK" they sql like skip it and all the step's that follows!!! (i see...more >>

Hi, Im trying to set up an ASP that will trigger a DTS package. Have seen the example on sqldts.com: http://www.sqldts.com/207.aspx And I can get his working OK. How would one alter this code to include any globals variables that I want to pass to the DTS package? Thanks, Red. ...more >>

We have a DTS package that runs twice a day. this package gathers data from an AS400, FoxPro for DOS, and 2 other sql server instances and the data is used for reporting purposes through Crystal Reports. If a report is requested with invalid parameters, a Lock Mode of IS (Shared Intent) is made ...more >>

i've got an ssis package that includes a data flow task that runs successfully. however, none of the subsequent tasks will fire, no matter what kind of value i attach to it (ie success, failure, completion). i've even tried changing the evalution operation from constraint to evalution and e...more >>

Hello, I need to export data from one database to another. One of the tables in the destination has an extra column which is a identity column. How can i inset an incrementing value into this column. This column does NOT exist on the source side. Thank you, David...more >>

Good day, when I execute a simple DTS package from DTS Designer in Visual Studio, it takes 5 Seconds to execute. The same package lasts about 50 seconds when I start it via DTExec in a stored procedure. I can see in the verbose output of the package, that it must have done nothing most of the...more >>

I have been using dts packages for some years then suddenly, yesterday, the ActiveX Script Task properties window changed. I can no longer see the code. This page does not allow me to paste a pic so I will try to describe what I see. Normally there is a top line showing the ActiveX task icon ...more >>

Which login runs the sql server jobs: Is it the login defined as owner on the job or is it the login defined on sql server agent. Thanks Jack...more >>

I have an SSIS package that emails a spreadsheet exception report. Naturally, I only want to send it, if there are exceptions. What can I use to query for the exception and only allow the workflow if Count(exception) > 0 thanks in advance, bob....more >>

I have this package that exports data to an excel file. At the end of it I have an On Success workflow leading to a Send Mail task that is supposed to send the excel file as an attachment. I keep getting a message saying that the Mail is unable to open file. Apparently the connection stays open ...more >>

Hi, I need to execute a DTS that have a couple of steps and one of them is a process task that simply call an exe file i made that will send an email to warn the user. What happens here is that the process task executes my exe file but it doesn't wait for it to compete and fires the next ta...more >>

I have used above exe to Install my DTS Package in SQL Server 2005. An entry is created in the sysdtspackages90 table. 2 Questions: 1)Where in SQL Server 2005 should I be able to see the Package itself? 2) If I want to run it manually, when I double click on the dtsx file on the Database S...more >>

Hi I'm using SSIS to bring data from one SQL 2005 db table to another. They both have SP2 installed. The destination table has six nvarchar(max) fields which are converted from nvarchar(4000). When I run the package in debug mode I get the following error: "Expected the TEXT token in da...more >>

I want to Execute SSIS package by passing parameters from command line just like we could use DTSRun command in sql server 2000. Please let me know. Thanks...more >>

I am new to dts packages. I need to export data on a daily basis from SQL to Excel and would like to use dts to accomplish it. The data structure will not be changing. I have the option of creating a new Excel file each day or appending a new worksheet into 1 main Excel file. My preference...more >>

Geeks, I am a Biztalk guy, I receive a flatfile of 1GB approximatly everyday and have to transform another flatfile format with in 30 mins of time. As for as i know flatfiles are converted to xml in biztalk which results 3 times bigger than the souce flatfile in biztalk databases. From va...more >>

Since installation on Windows vista, I see no data flow destinations when the data flow tab is selected on a new integration services project. I AM running VS as administrator. Using the ssis wizard produces perfectly good packages with destinations and all. any ideas? ...more >>

Hi, I have created an XML Configuration file within the Designer and have added my database connection details. How do I get my TSQL Task to use this connection. I have currently set to use a connection I have created within the connection managers window. Thanks in Advance. ...more >>

hello... I have a problem with a package in SSIS... The package executes an Execute SQL task that fill a System.Object variable with a table resultset. In the development PC, the package execution takes 10 seconds, from the beggining until the end But, in the production server, the sam...more >>

I know this has been here before (but not for several years), but I am getting this message on *some* data (still investigating). The prior solution (blobs at end) does not seem to be relevant. Old replies suggest putting BLOB columns at end. I have done this, but there are 3 BLOB columns. Mos...more >>

Hi, (Firstly, I have cross posted this to a DTS group as well as a vbscript group, as Im not sure if this is a DTS issue or script issue. Apologies if I upset anyone) I have an ActiveX running within a SQL Server 2000 DTS package, which I am trying to adapt to create a bunch of excel sprea...more >>

Hello all, What books do you guys recommend as good tutorials for SSIS. I've gone through the tutorials in BOL, but have yet to create a successful package. Have given up on the SSIS learning for the time being and gone back to using DTS packages. Thanks for any help anyone can provide...more >>

Hi everyone, I used this command to run a package: dtsrun /S "local"/N "leitest1" The job failed. I got this error message: Executed as user: Main\jih. ...version guid, or a source filename. DTSRun: Invalid command options Usage: dtsrun /option [value] [/option [value]] .... O...more >>

Hi, I need to import data from Access table to SQL Server table. When I choose the Access file I got this message: Error Source: Microsoft JET Database Engine Error Description: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. ...more >>

i've seen sample code using an activeX script to modify the command line of a execute process task, but i'm unable to get these to work. i need to change the argument, not command line, of an execute process task from a script task. does anybody have some sample code i can look at? i can't se...more >>

I have a DTS package that takes the results of a SQL query and writes it to a text file. One of the columns in the text file needs to be a counter (value on first row is 1, second is 2, etc). Is there a way to do this without sending the data to a temporary table with a autoincrement identity ...more >>

I am using SQL 2000 and executed a DTS package and runs sucessfully on the designer platform. When I scheduled it to run on the SQL Agent, it hangs. The package was designed as new on the running server itself and saved with sa password. What can be the problem ? Can anyone please advise ? ...more >>

Hi: I was wondering if I have several DTS files if it is possible to save them on a SQL Server via a script that references a path to the files. I would like to know the same for both SQL Server 2000 and SQL Server 2005. Thanks, Kayda ...more >>

I am I am looking for the best method of automating an INSERT query in SQL Server 2005 Code: ------------------------------------------------------------------------------ -- 'INSERT INTO SaltInvWhOpen (StockCode, Warehouse, TrnMonth, TrnYear, OpenBalQty, OpenBalCost)...more >>

Hi, I have following in put person ID____________Choice ------------------------------------- 1___________________Apple 1___________________Banana 1___________________Peach 2___________________Lemon 2___________________Coconut and I want to translate in following person ID___________...more >>

Hello DTS discussion group, i'm going crazy with one maybe simple problem on executing DTS on SQLSERVER 2000. Situation: I have in my local environment a DTS-Package, which starts another DTS- Package. I used both dtsrun as command line task and the exisiting Execute Package Task from DTS...more >>

SQL 2000 on Server 2003 I've created 8 different DTS packages and scheduled them by right clicking on them. 6 of them work fine. However, 2 of them get the same error when the job is run (they run fine if I right click on the package and select 'Execute Package'). Here's the error: DTSRun: ...more >>

I'm using SSIS to bring fixed width files into the database. After the package runs the data has blank spaces at the end of it that need to be trimmed so "John Doe " would become "John Doe". What is the best way to trim the blanks when using a SSIS package to do the insert? Thanks, M...more >>

Instead of writing "Hello" I want it to read a value from a cell in the excel sheet I am running this from. The code is in VBA: Public Sub oCustomTask1_Trans_Sub3(ByVal oCustomTask1 As Object) Dim oTransformation As DTS.Transformation2 Dim oTransProps As DTS.Properties ...more >>

Hi, I am new to using DTS and just created my first DTS package that imports a text file into a table. The package works fine and now I have to add a trigger or equivalent that will do the following: 1. For each record where the member number doesn't already exist insert the record int...more >>