I'm having a problem getting data from a flat file to transform/load into a MSSQL table. The transformation is a simple copy. The transformation step fails with this message: "Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump Step Error Description:The number of failin...more >>

Hi All, I'm having a bit of a problem with a DTS package that is accessing our AS400 for data. The only time is appears to fail is when I schedule the job. I can run the job within the DTS designer and when I execute it from "Local Packages" folder, but when I schedule and run the job, it...more >>

I have a database that has a column for the first name and a column for a last name. I need to use a dts report to merge these two fields into an additional column in the database. I need to keep all three columns. Any suggestions?...more >>

Hi I am trying to read a dbf file using OLEDB but I can't get the entire field. I suspect that it is because the OLEDB measures the size of the field assuming it is UNICODE characters and then it reads that number of characters (another thing that supports that that when Access or SQL Server ...more >>

I am attempting to join 2 tables on 2 columns with a left inner join, using a merge join component. I set col1 to a sortkeypositiion of 1 and col2 to a sortkeyposition of 2 (on both tables). This consistently fails with the following: 'The column with the sortkeyposition value of 0 is not ...more >>

I am trying to generate an XML file based on the result of a SQL Query. In the absence of an XML Destination shape, I've done the following... 1. Exec SQL Statement returns XML & populates a string variable. 2. Use a script component to create a file and write to the file with the variabl...more >>

Ok, The good news, I've created 6 tables from a single input table source. Each record of the input source had a primary key that was included in the 6 destination tables as a "foreign key". Now I need to take the 6 tables and re-assemble them into the original table format to b...more >>

Source is varchar, want to convert to datetime but need to null any bad dates first. Can't use the derived column transformation as it doesn't support the ISDATE function. I could feed the error rows to a derived column which converts to null based on errorcode and then union all with th...more >>

I am currently having an issue with SSIS where I created a package, copied that package and added it to the existing project, renamed the copied package, and made modifications to that package so that it performed the same functions as the first package, but on different data. Because I nee...more >>

Good evening, I'm working with two sql2005 databases on the same server. I would like to copy the stored procs, views, and udfs from one to another, dropping any duplicates on the destination side. To do this, I created an Integration Services Transfer Objects Task in Visual Studio 2005...more >>

Hello there I've heard about Encripting the DTS, to secure the transfare. Where can i declare it? and will it slow the transfare of data? ...more >>

Anyone have an example of calling Reporting Services through VBS in a DTS package? TIA ...more >>

For example, I start the DTS import/output Wizard on my workstation C. And I let the Wizard transfer tables in S1 to S2. Will all the data be transfer from S1 to C and then to S2? or directly from S1 to S2? So is it better run the dts wizard on S1 or S2? The task manager shows dtswiz.exe u...more >>

While loading excel, By default first row is the column header. Is is possible to specify the second row as the column header? Thanks ...more >>

hello i am trying to assign a value from a "recordset destination" column to a package variable with a ForEach Loop. The recordset column type is [DT_I8], based on an SQL Server query column which is a bigint type (DENSE_RANK() function return value) The package variable type is Int64 and t...more >>

Hi. I am trying to run a simple SQL Server 2005 Integration Services package against a single Oracle database table. The table has several columns having datatype NUMBER without any precision. When trying to open the Columns tab in the OLE DB Source Editor I get an error telling me t...more >>

I have just upgraded from the June Community Technology Project to the September one and I have been having loads of problems with all my SSIS Projects since. One of the biggest is the my for each loop container which loops around a series of csv files and puts them into a data flow task. The pr...more >>

Hello I'm building an SSIS package programmatically using C#. I need to use a Script Component in the Data Flow. But I'm having difficulties in adding and configuring a Script Component through C# code. Can anyone please help me with some samples. Thanking You ...more >>

I've been completely unsuccessful so far in getting the SSIS service to start under normal circumstances. I've got the SQL 2005 RTM DVD and a clean, brand-new installation of Windows 2000 Server (Service Pack 4). All system requirements have been met according to the SQL installer. I choose...more >>

When creating a new ssis package with the source as a text file, how do I specify using a space as the col delimter? { } dosent seem to work. TIA ...more >>

Hi... I'm using SQL 2K5. I creating an SSIS package that is entering data into one table that has an identity field, once I enter the data, which would be one record. I need to get that identity number for the next step in my package... How can I do this? ...more >>

I had exported MS SQL Server DTS to Visual Basic File (.bas). I wonder how could execute dts.bas via vb.net ? Please advise. Many thanks. ...more >>

Hi All, How can I get the server name on which the DTS package runs dynamically. for instance, when a DTS package is success, I want to send an email, and the email should contain the server name on which the DTS package is running. Is there a way to get the servername through an ActiveX...more >>

Hi there. I'm trying to convert hundreds of DTS packages over to SSIS, some of which are rather complex and have several components which wont migrate nicely. I'd like to use the Execute DTS 2000 Package Task for many of the packages - but the problem I'm encountering is that no matter what ha...more >>

Hello, I have a DTS package in my SQL Server 2000 database. What it does is to import records from a text file in a Floppy disk (a:\) into a SQL Table. However, when I execute the DTS via Query Analyzer I get this error: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy D...more >>

HI I have DTS pacakge to process four cubes , Situation here is, if any reason first task failed, DTS stopped. But I want, If one task failed, send email notification and goto next step. While doing this I addedd following Task 1, on failiure , goto sendmail task, once sendmail task su...more >>

Connection 'DatabaseName' for Task 'DTSTask_DTSExecuteSQLTask_5' does not support joining distributed transactions or failed when attempting to join. Unable to enlist in the transaction. New transaction cannot enlist in the specified transaction coordinator. I have Checked the DTC service i...more >>

Hi All, In DTS project, I have used Global Variable called Last_Export_Date which store DateTime of Last Export date. I am updating this global variable in the Last Task of my Package. So My Insert Statement which i am calling in DataPump Task is like SELECT * FROM DBO.T209 WHERE C3 > ...more >>

(I just got through praising DTS to a colleague who hadn't used it since a bad experience with it back in SQL 7.0. Good thing I didn't show him the following!) I've somehow broken the DTS Designer.Here's what happens now. 1) Create a new package 2) Drop an ActiveX Script Task onto the desig...more >>

Hi, I'm trying to load a flat file into SQL 2005 table. The file has about 250 columns(fields). When I try to use the Import wizard, I'm getting truncation errors, indicating that the length is smaller. If I correct that and proceed, I'm getting the error again but for a different column....more >>

Hi, One dts would transfer data from SQL to oracle by using Microsoft ODBC drive for oracle. After start the job, the oracle won't see any record transferred 20 minutes later. Why connection take so long before dts starting transfer data to oracle? Is there any setting I can change to in...more >>

When using DTS to import datetime data, we find that when the source file contains a datetime such as "2005-12-27 12:47:21AM" it converts it to 12:47PM. If I insert the above value, it gets converted correctly. I have tried fooling with the datetime string conversion and no matter what token...more >>

I am in a bit of a dilemma. I have a DTS package set up to query a table some some string concatenation and eventually spit out the results to a text file. When running the T-SQL code from query analyzer, my results look perfect as they should, the correct encoding is retained and all, ex...more >>

Hi, I scheduled several DTS packages for regular daily data transfer. Shall I somehow ajust time of execution of these packages? Will it be huge impact on SQL Server performance if jobs start simultaneously? ...more >>

I have defined a "Microsoft Data Link" Connection by using specified UDL in UDL Design Sheet, I would like to retrieve the Data Source and Inital Catalog at Data Link Properties such that I would be able to execute my Package in different server and db. my inital catalog and data source is in...more >>

I've a sql server agent proxy account named "sqloper" with user privilege. I login into my windows server with "sqloper" account, if I run a DTS with dtsrun.exe command in a DOS session the DTS works fine, but if I create a job with an application login (not SEVER ROLE applied) to execute the s...more >>

Hello, Can anybody help me with dynamic transformation mapping? I have a various Excel files I need to import into SQL tables. I created a DTS that checks a specified directory and load Excels into db. DTS has 2 global variables for the source file and the destination table. It works fine if...more >>

Hello everyone and Happy New Year! I have a need to query application databases across multiple servers for row counts, object counts, etc. In the past I have used Query Manager to do this server by server. I would like to write a DTS package on a central server that uses a source file ...more >>