I am executing a Data Reader task connecting to a 2000 sql server using a ..net/sqlclient data provider. The task fails after 30 seconds and returns the following error: Error: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the opera...more >>

I am passing multiple variables from Dataflow into a SQL Task in Control Flow. In SQLTask I have an insert statment, joining multiple tables and also using variables. For example Insert into Table1 (Col1,Col2,Col3,Col4) SELECT ?, ?, empID, getdate() from blah1 where blah1.col3=99 ...more >>

Hi, Is it possible to convert string data to integer in SSIS ? I tried using the cast -- (DT_I8) and the Data Conversion data flow item. It errors out saying "Failed to perform type cast". The DataConversion doesnt work either. Please let me know if you know how to perform this conversion....more >>

Hi, I know this subject has been around for quite some time now, but I couldn't find a decent answer. Scenario is simple. I have two meta-data tables, the first I'll call defTables and the second defColumns. The first table defines names of source and destination tables, and the second of s...more >>

I am using Notes Notes SQL Driver to pull the data from lotus notes database and add it in SQL 2000. For this I have created a table for destination in SQL 2000 database with identity column. While transferring the data, it works well till last record, but once it on last record transfer, it t...more >>

I am passing multiple variables from Dataflow into a SQL Task in Control Flow. In SQLTask I have an insert statment, joining multiple tables and also using variables. For example Insert into Table1 (Col1,Col2,Col3,Col4) SELECT ?, ?, empID, getdate() from blah1 where blah1.col3=99 ...more >>

Hey guys, I am importing CSV files from a directory. These files may either have 5 columns or 4 columns (missing the last one). I wish to import the 4 column version into an errors table in the db, meanwhile the 5 column version is imported into the live table. Anyone any idea how to go ...more >>

How can I determine what is causing the following package to fail? Error: Error 0xC0012050 while loading package file "C:\Documents and Settings\wardte\Local Settings\Temp\2\InnerPackage.dtsx". Package failed validation from the ExecutePackage task. The package cannot run. . ...more >>

Hi Everyone, I'm migrating a SQL Server 2000 instance to a new box running SQL Server 2005. I've installed the SQL 2000 DTS components on the new box which runs 2005 cause i need my existing DTS packages to keep running on the new box. I exported over the DTS packages, and am able to execu...more >>

Here's a situation you won't find every day. I have a big database project that I am taking over. There is a set of 6 DTS Packages that import 6 tables from the Timberline accounting software via ODBC every night. A 7th DTS Package calls each one of these 6 DTS packages and is Scheduled to r...more >>

Hi, I need some help from you guys. As part of my new job, I need to create a DTS Package to syncronize the production and QA Databases.The steps to follow are Say for example the databases contains more than 100 tables and we need to copy the contents of few tables (say tab1, tab2, tab3.......more >>

We're having to move SQL to a new server, which must be a new name. Previously, I had been using an old name, and when the server was replaced, we just gave the new one the old one's IP and name when we brought it online. Is there a way though, for me to make DTS and jobs in SQL "portable"...more >>

Does anyone have any suggestions for a decent DTS book for a beginner that explains the product in pretty good detail that would enable me to utilize and get up to speed pretty quick with a decent index so that I can use it as a reference as well??? Any suggestions would be GREATLY apprecia...more >>

Hi all - Running into a problem with SSIS and a google search doesn't yield much help. I have a package with multiple tasks and about 10 OnError event handlers defined (one for each task). I need to go in and change the System::Propogate variable for some of the event handlers to make sure...more >>

I'm using an "Integration Services Project" / .dtsx package to load CSVs into my SQL Server 2005. Many files represent dates as "YYYYMMDD", and I want to convert those to feed a SQL "smalldatetime" column. How do I do that?...more >>

I have a query that I need to do subtotals on. The query is as follows: select ba, rg, sum(order_qty) as oqty, sum(order_val) as oval from sales_ord_curr_yr a inner join sales_product on sales_product.prod_cd = a.prod_cd inner join tblproducthierarchy on sales_product.level_1_1 + sales_...more >>

I need to connect SFTP site to download data file. Is there any way I can create a Secure FTP task in SSIS. If there is what is the best way to do. If SFTP not supported natively in SSIS then is there any their party tool that I can use?...more >>

Hi, I've many rows and I want to split them in many columns, with SSIS. I've this scenario: INPUT TABLE id date -------------------- 1 2006-02-04 1 2006-03-08 1 2006-10-15 2 2006-03-07 2 2006-09-17 OUTPUT TABLE id date1 dat...more >>

Oracle 10 import DTS package with 11 tasks, 1 task per table. Yesterday I added more tasks after this package has been working for a month. There are 2 tasks (Delete from existing table, transform Oracle to SQL Svr table), 2 connections (Oracle, SQL Svr 2k) and 1 workflow "on completion" aft...more >>

Hi everyone, I have a problem with a DTS process which imports from excel to SQL. I have tried this dts process on both SQL 2000 and SQL 2005, and they appear to both be behaving the same odd way. The DTS process never is able to pick up any data residing on row '1' of the excel spreadsh...more >>

Hi, I am new to DTS world. I was able to save a dts package (in local packages) and execute it manually without problem. I am trying to schedule it to run daily but nothing happened on scheduled time. Could anyone please point me out? Where can I check the log? Thanks. ...more >>

Hi. Here's what I need to do in a DTS package and don't know how: Insert all the values from an Oracle view into a SQL Server 2000 table where the value from the source doesn't exist in one of the columns of the destination table. Thanks. ...more >>

Hi - I currently have a DTS package that takes raw data from a SQL table and inserts records into several tables via a custom ActiveX transformation. The package uses logic to determine which table to insert into and then calls DTSlookups to perform the inserts. The # of records I'm working w...more >>

Hi, SQL 2000 SP4 DTS Windows 2003 Server sp1 We have two diferent packages (parent and child) to load text files. The child package has a condition node that decides if all steps should be run or only the mandatory ones (the process checks the number of files to be processed, if it is = 0 th...more >>

Installed an upgrade from 2000 sp4 to 2005 sp1. Trying to import simple flat file of 30,000 records but getting error that told me nothing. Somebody suggested installing SP1 on my local machine to get better error reporting, which I did. Now the error is a truncation error. However, in the...more >>

Hello All, I come from a DBA back ground. So, I'm a new to DTS programming and VBScript programming though I'm reasonably familiar with the DTS UI. I was going through Ken Henderson's book and Wrox book in the hope of learning DTS programming. I was going thru the "Parameterized DTS Packag...more >>

Using DTS, I am trying to import a numeric field (5,3) in Visual Foxpro into a field in a SQL table, but keep getting this not-very-helpful error message: "Error at source for row # 12. Multiple-step OLE DB operation generated errors. Check each OLD DB status value, if available. No work...more >>

Hello, I have a Bulk Insert Task to load records from one text file to a SQL Server database table. My problem occurs when the input text file has some special characters like '=E1' or '=F1'. After executing the task, the corresponding row in the database table contains symbols like '=DF' i...more >>

Hallo Everyone, I have parent- child tables that I would like to transfer from one SQL 2005 database to another SQL 2005 database using SSIS. The parent table has a primary index with a seed=1 and autoincrement=1. The Child table uses the parent primary index as a foreign key. I have anothe...more >>

Hi I have a Data Driven Query task including a lookup. If the lookup returns anything, then the Update query should be run - otherwise, skip row. My ActiveX transformation looks like this (in part): MatchCatID=DTSLookups("LkpMatchingMDSCatalogueRow").Execute(DTSSource("MDSCatID"),DTSSour...more >>

I have created an active X task to open, refresh, and save an excel workbook prior to mailing it in a send mail task. When I execute the step, I get a dialog message that "This action will cancel a pending refresh command. Continue?" Even if I select OK, the workbook does not update, but th...more >>

Hi All, I tried to upload my clients 2005 db to my webhosting site (MSSQL 2000) and .... "Error: The destination server is not 2005" Surely this can't be, no backwards compatibility?? there must be a way,...? (And no way am I purchasing 2000 just for this!, then manually re-creating th...more >>

am totally new to VB and i have just started to learn it. I am stuck at the very basics so i would really appreciate any help. What i need to do is transfer the information from an Excel file to a SQL server table via a DTS package by copying columns. During the transfer i need to perform some ...more >>

Hi, I have created a simple package that returns success or failure based of the existance of a file. The package accepts uses 2 variables varPath and varFileName. When I use an XML config file to set the values everything is hunky dory (that means good ;-)). What I would LIKE to do ...more >>

I'm pretty new to SSIS, and I'd like to be pointed in the right direction to achieve a problem I've hit a brick wall with. I would like to concatenate a set of strings, but not across columns, but down a row - a String-Aggregation like function - and create a new column with the output. ...more >>

In SQL 2005, what's the best method to import a file(via an SSIS package or DTS that would have a schedule) if that file: 1) Exists 2) Is not empty 3) Is New (and by new that would be newer than 3 days old) We previously had an activeX script that ran but took advantage of xp_getfiledetai...more >>

I am trying to set the value of the variable User::ErrorMessage dynamically using the Script Task. I would like to construct an error message containing carriage returns for use with a Send Mail Task. ReadOnlyVariables : User::DWAuditStepDescription,System::StartTime,System::EventHandlerSt...more >>

I have a DTS package which has two data transformations tasks- If 1st data transformation task fails then package executes the 2nd data transformation task and subsequent sql steps. Here is the problem I am facing - When I schedule this package as SQL job, it shows as failed everytime 1st ...more >>

Does anyone know if a wildcard can be used in the Source File Name when using the FTP task in DTS? I need to logon to a remote FTP server, and pull all files down to a directory on another server. I tried to create a .BAT file to do this, but I couldn't get it to write the files to another s...more >>

I have a couple of questions regarding a package I am writing. Hope you ca help: 1. I have a "Transform Data Task" that is moving fields from a file directly into a table. There may be exceptions regarding fields that cannot be null, non-numerics to integers, etc. Thus, it is worth catching...more >>

Hi I need to update a table in our datawarehouse, with new records from our production system, but I've problems creating an SSIS pacakge to do this. Basically I just need to find the company records in our production that doesn't exist in the Datawarehouse. In the package I've created, I h...more >>

Hello all, You all are probably going "HUH?!?!?!" by the subject line. Yeah, I know, a contradiction in terms. We have a client sending us data in fixed width text files--one month per file. The problem is that the width of each file varies from month to month. For example, in July & Augu...more >>

Hi I am new to DTS. I am creating a DTS package which imports data from a text file to a table in the database. I need to define a format file. I have alreay created the format file based on the destination columns in the table.I just need to know away to use it in DTS. Ex: Source file...more >>

Hi, I am trying to run the dtsrun utility in a "Windows only" authentication mode. For the -U and -P option, i am providing my network user id (domainname\userid) and network password. However I get an error saying that "Error string: Login failed for user LOCALNETWORK\KRAO'. Reason: Not as...more >>

Hi I'm running a simple copy database objects DTS between two databases on the same server as sa. However, right at the end of the dts, I get the following error: SETUSER Permission denied in database 'XXX' where XXX is the destination database. Any ideas? Regards Ray...more >>

I am creating a package using SQL Server 2005 Integration Services. I have .XML file where is stored Path of MS Access file. I want "XML task" to read this .XML file and store Path value in the package level User::AccessPath variable. My construction does not work. If anybody knows why, please, ...more >>

I am creating a "GENERIC package" in dts 2000 that will use a dynamic connection string from user input. Since the source table can be different every time, I need to delete existing transformations, which I did using an AciveX script task, now I would like to create dynamic column mapping in...more >>

When I use a DTS Send Mail task to send an email with a mail attachment ( "testfile.txt" ) to a non Outlook mail client it is appending the path to the file name resulting in attachment names such as: __File01_SharedFiles_Paul_testfile.txt is there a way to prevent this from happening?...more >>

Hi - I am porting a system from DTS to SSIS. The old version runs packages programmatically loading and running a DTS.Package2 object. I can load and execute and SSIS package using the Microsoft.SqlServer.Dts.DtsClient API, but the package runs locally. I have a lot of questions about thi...more >>

I am trying to setup a database copy DTS package to copy a database from one server to another. I created the package via the database copy wizard and everything looks ok. However when I run the package I get an "Unspecified error" error after a few minutes. Does anyone have any suggest...more >>