I import data from xls file into a table using saved DTS Package. The lenght of one field exceeded 300. I changed the lenght of the field in the source table to 1000, but still there is an error as below: Error at Source for Row number 156. Errors encountered so far in this task: 1. Data f...more >>

I have a free table directory with FoxPro tables. I need to transfer the data from them into SQL 2005. Back with SQL 2000, I did this using the DTS Wizard. When I try to do the same in 2005, 1) I use MS OLE DB Provider for Visual FoxPro. When I test the connection, it's successful 2) Select th...more >>

We are SS2K and need to move a package to other (remote) SS2K instances sitting behind firewalls. I read or heard somewhere, that transformations and mappings may be lost when opening a package in a different instance of SQL Server when the remote instance can't communicate with the instance o...more >>

I have 3 tables: Import_accomodation: - several attributes..... - continentname - regionname Continent: - ContinentId (PK) - ContinentName Country: - CountryId (PK) - ContinentId (FK, can be null) - CountryName The import_accomodation table is a flat table from which I want to tr...more >>

Hi, When I execute the following command: exec master.. xp_cmdshell 'dtsrun /S Server name/N packagename /E' I am getting following. DTSRun: Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not been called. Please help m...more >>

Hi, Is it possible to extend the existing data flow components in SSIS? For example, I was to add a little bit of functionality to Derived Column, Conditional Split, Fuzzy Matching, etc. Most of the functionality is for logging, but not all of it. Thanks, ...more >>

Hello all!!! I have the following problem using SQL DTS package scrit executed within Visual Basic. The data source is a Text File. The file type is ANSI The file format is Delimited The row delimeter is vbCrLf When the package is executed, I get the error "Row Delimeter not found". But...more >>

Hi everybody, I'm trying to make a dynamic data transfer with Integration Services. I have a loop on many tables and for each of them I fill variables : - SQLScript : whitch contains the SQL select script - DestinationTableName : witch contains the name of the destination table In my data ...more >>

I have a dilema I cannot figure out. I need to run a step in a DTS package that checks a count in a table. If the count does not meet my criteria I need it to error out and run a batch file to turn off a service on a different server. I have tried running another DTS package (shelling out ...more >>

Hello! I have a few File Tasks in SSIS that rename files. Through Visual Studio I can execute the package and it works great. When I attempt run this pacakge via SQL Agent, Command Line or the Integrated Services Engine it will finish with success however the files that are supposed to be re...more >>

hi everyone, I'm a new comer to this group and also i'm new to sql, DTS like that. now i want to do some system monitoring tasks using perfmon and have to write the results into an sql table. by searching i came to know that i can run a .bat file which in turn runs the DTS Package causing the ...more >>

Iam getting the following error at the final stage of import/export wizard of sql server 2005 while creating a package to transfer data from excel to sql server. "Save to sql server failed no description found" I used sql server as the package location. Kindly help to resolve this issue. ...more >>

I have to write some sql that has to create a table from which a report runs that spans over the end of this year. It's code to build a table that a sales program report is generated from. The program itself runs until the end of January. From now thru January 2, orders in the program co...more >>

Hi, I have many DTS jobs that run during the night. Last night three jobs failed with the same error "Unable to open Step output file. The step failed." What does this error message means? Any help willbe highly appreciated. Thanks....more >>

Hi, I get the following error from the SSIS: "The task ... cannot run on this edition of integration services. It requires a higher level edition." The package runs from my Visual Studio, but when I deploy to the Integration Server which is not on my PC it throws me this error. I'll re...more >>

Hi I have a package with many tasks, which are sequentially linked "daisy chained", I was wondering if I am not reliant on the order of execution, can I run all these tasks simultaneously? Which would be quicker? Kind Regards Ricky ...more >>

What could possibly be wrong with this statement? MsgBox(Dts.Variables("User::sDesertIslandFile").Value.ToString) ...more >>

Hi, I have an overloaded column from a csv file that can have two different values. The rules are, if the column is numeric then that should be put in the numeric column. If it is alpha-numeric, then I want to put it into a string column. I've tried to use the derived column transformatio...more >>

I want to automate the import of certain databases to SQL Server. Rather than having to interactively use the Import/Export Wizard, I wrote a WSF program to prepare the DTS Package, Steps, and Tasks, using DTS Wizard job saved as Visual Basic. The file I am working with is DBaseIV. After it fa...more >>

Hello, I am trying to use the Foreach loop in SSIS to loop through files. For some reason the File Enumerator collection is missing from the drop down in the foreach loop properties. This is not an issue if I log directly on to a different server. But when using the business intelligence s...more >>

I'm not even a novice on SQL, so this may be out of my league, but I need to find out how to convert SQL Tables to Flat files. I imagine I will need a converter of some sort, right? The scenario is... a subcontractor sent files to us in SQL Tables unlike the last year when they were sent in a ...more >>