Sir, I am not able to find out how maximumerrorcount works. can any one expain or provide me a sample. regards, Guga ...more >>

How to add header row in a excel file when data is exported from sql table to excel ...more >>

I created a SSIS package on my computer locally. It has an OLE DB connection to my server, using an account with sysadmin privelages. When I debug the package it is able to connect and runs perfectly. However, when I create a job and specify the package on my server, the job fails citing:...more >>

Hi SSIS Guru's, I'm trying to design a console app that uses the SSIS object model to move data between 2 tables that have the exact same metadata definitions. I pasted the code below: When I run the code I get the following error: "component "OLE DB Destination" (2)" failed validation an...more >>

Has anybody been able to get a CopyObjectsTask within a 2000 DTS package to run using the DTS Designed in SQL 2005? I have a SQL 2000 DTS package that I am running on a 2005 instance and everything runs fine until I hit the CopyObjectsTask....more >>

According to all documentation I have found, you are supposed to be able to run DTS packages created in SQL2000 after upgrading to SQL2005. It seems that if I have a DTS with an FTP step in it, we are able to run the DTS, but we are UN-able to run it from a Job. The error is, 'Unspecified E...more >>

I have some 2000 DTS packages that I am running in 2005 using the 2000 DTS component. I have setup the databases as 2005 but am still using the 2000 package. Everything works just fine in the 2000 environment and the database objects are the same in both the 2000 and 2005 environment. Ever...more >>

I want to call a sp in DTS, where SP return output from a #temp table. Its not working . Is there any other way ...more >>

I am trying to create a SSIS package that copies a bunch of tables from a SQL Server 2000 DB to a machine with SQL Server 2005. I can see and select the tables in the editor, but when the package runs, I get: Table "XXXXXX" does not exist at the source. On both sides, the tables are dbo an...more >>

Hi, I have 200 mil records in one table need to be transferred from one server to another server fro test.What is the best way to do the transfer by passing the log? Select into? Thanks, ...more >>

I have 2 servers: one is WebServer, the other is DBServer SQL Server is installed on DBServer, I created a DTS (exporting from table to Excel file), the destination file is on WebServer( \\WebServer\aaa.xls). I successfully run the DTS in Enterprise Manager, but failed when running by Stored ...more >>

I have a project with 12+ packages, all using a shared config file. I have placed the config file in the same directory as the packages, and all of the packages are using relative file paths to find it. When I set my Project Settings to CreateDeploymentUtility=true, I get a build error sayin...more >>

How can we pass transform data task source and destination dyanmically . Or can we call a transform data task from activex script dynamically in dts ...more >>

Hi! I'm have a DTS package that imports a text file into a SQL 2000 db. My problem is that one of the fields in the text fil contains a price with comma as decmal separator. The text file: ArtNo;Name;Price 1;Name1;1,5 2;Name2;2,5 3;Name3;4 4;Name4;5 5;Name5;75,35 In the SQL table the Pr...more >>

I have a package collection with one parent package that calls several child packages that share a common configuration file referred to using a relative path (everything is in the same folder). If I put the child packages and config file in a different folder execute the parent package, th...more >>

The connection for a Check Database Integrity Task allows selection of specific databases. However there appear to be no equivalent configuration properties for these selected databases. Is there a workaround for this? (Preferably not editing the dtsx files or ensuring the names of the data...more >>

Is there an easy way to dynamically configure DataFlow tasks in your package? For example, I'd like to be able to pass in a variable for the name of the source and destination tables, and have the package read the metadata for these tables in the dataflow task. In DTS you could do this, but in...more >>

I am trying to do a load on a data warehouse staging table using SSIS where I want to insert new records and update existing records based on existence of the key values in the table. The input records are the change records coming from an OLTP system. This would seem to be a very typical...more >>

I am trying to port a job where there are several DTS packages in various steps being called from cmd. How can I identify what package names are associated with what job step so I can move the DTS packages as well? thanks Meenal ...more >>

What is the best way to remove trailing spaces in a dataflow in a SSIS package? The SRC OLEDB connection is to a Visual FoxPro DB - all of the columns in the tables are CHAR so trailing spaces are included in the dataflow. The DST OLEDB connection is to a SQL database where VARCHAR fields are ...more >>

Hello. Our server crashed and I'm in the process of re-installing everything. We use SQL 2000 and I have all the databases from backup. I now have about 50 DTS packages that I need to open and save into SQL. Is there a way to do it so I don't have to manually go through 50 DTS packages? T...more >>

I was wondering if there was a way to further examine a redirected rows from a lookup? For Example: If I have a lookup comaring two sources (Flat File against a DB Table) and redirecting rows that do not match---Can I perform a transform that will detect the columns and values that did not ...more >>

Hello All, I'm trying to go from a Dynamic Properties Task (or an ActiveX Script Task) to an MS Excel 97-2000 Connection in a DTS Package. It doesn't matter what I use: On Completion, On Success, or On Failure. I continue to get the error message listed in the Subject line of this post...more >>

I've been struggling with trying to import an entire database from sql2k to 05 and keeping all the indexes, keys, etc. intact. If I just run a straight dts, then only the data gets imported. So I referred to my trust wrox SSIS book and it showed me how to imports a dts package from sql2k int...more >>

I deleted a dts package and need to restore it. I understand that the package should be in the msdb table, but id not. We do backup the server to a tape backup, but I do not know where the dts packages are stored. Is it in the msbddata.mdf file? If so, if I retore just that file, is it enough and...more >>

I work for a poultry science company and we generate about 15 csv files per day from an egg scale we use to grade and package. One csv file is one record, and each row represents a field much like a column does in a table. I believe it's called a line-dependent csv. The staff member who o...more >>

I have a shared configuration file used by multiple packages. It contains connection strings for connection managers. When I open up my project I get the following error for most packages: There were errors while the package was being loaded. The package might be corrupted. See the Error...more >>

Hello, Newbie here using DTS. I have written a script that should read records from 1 table and insert or update the records in another table. These tables exist in the same database. When I run the script I get a message that it completed succesfully. However, only half of the records ...more >>

Hi.. I need to extract all employees with state='CA' from a sqlServer 2005. Solution so far: What we have done is created a 1) "DataReaderSource" to the DB 2) Then a "conditional split" filters the state="CA" My questions is.... is it that I first get all the data from the DB an...more >>

Is it possible to show the control flow tab inside a custom application. Is there a viewer for this similar to the Data Mining algorithms viewers? ...more >>

I have a script task that generates Foreign Key drop and create scripts. The output of the task goes into variables. I have this task in its own package, and can successfully pass input variables to the child package from the parent package. My problem is that I'm not seeing the updated v...more >>

I've got a DTS package that is moving data from one db to another on the same server. When the steps within the package are manually executed, all steps succeed. However, when the package is executed, one step continually fails, stating the number of errors exceeds the number allowed. I'v...more >>

What is the best way to completely copy a database to a new one? It has to include every diagram, table, view, stored proc, etc. ...more >>

In a database I made some diagrams. In the table view I added the custom column "decription" so I could descibe every field of the table This works perfect. Now I want to copy these diagrams to another database. I used DTS with "Use a query" to put all info from dtproperties in new databa...more >>

Hi, I want to schedule an SSIS package to run as a Job under SQL Server Agent. This package runs fine when I execute it by double clicking the package and setting associated properties, it also runs fine on my machine as a job but when I deploy this to another server it fails...? I've se...more >>

I couldn't import a database from sql2k to sql05 because toward the end of the import it would error. problem is it didn't provide any useful information. I ran the best practice analyzer utility on the sql2k db but didn't find anything that should make it crash when coping the data over. ...more >>

Dear all, I want to transfer a text file content to a SQL2000 table using DTS. When I use DTS and choose "run immediately", it works fine. When I set schedule to call in SQL2000 Job, and try to test the schedule by manual start, it shows the following error: The text file is fron Netwo...more >>