Chaps, we're trying to dynamically set username and password for an SSIS FTP Connection. However, the format of the connection string is not documented, as far as the setting of the login-properties for FTP is concerned. I have checked several databases and forums, but haven't come to any res...more >>

I am trying to use DTS to copy from an Excel file to a table (SQL 2000). The table has a primary key (say ID). As might be expected, when a duplicate key is detected, it terminates the copy. With Access one could use First/INTO/Group and have the copy just skip the duplicate. I cannot use DISTIN...more >>

Receiveing the following message: Error Description: The number of failing rows exceeds the maximum specified. Insert error, column 7 ('PERIOD_END', DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification. The DTS package this error was received on ...more >>

sql2k sp4 Howdy all. All of a sudden, my DTS Package is totally unusable. If I try to run it or design it, I get "unspecified error". I have verified that there is no corruption in both MSDB and Master. Ideas? TIA, ChrisR ...more >>

I'm trying to move some data from a tab delimited text file into a SQL Server 2000 database table using DTS and have run into a problem converting text data into smalldatetime. The format for the dates in the text file is CCYYMMDD, all text fields are double quoted. I created the initial tran...more >>

Hello all, 2 questions. First, lets say I have a network share mapped to a drive letter on my machine. Now I set an Excel or Text file connection to a file on this mapped network drive and save the package. If someone opens it on another machine with differently mapped drives, will the D...more >>

Hi all. i need really your help with the next error. haven't idea what is the problem. ---- DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error = -2147467259 (80004005) Error string: DTSStep_DTSDataPumpTask_1: Error at Destination for Row number 10919. Errors encountered so far i...more >>

I'm new to integration services. I want to create a centralized reporting system for our customers. Some customers have up to 1,000 sites and some are expected to grow past 2000 sites. The sites are running POS applications and I want to extract the POS sales data from these sites. Is it...more >>

Hi All, I have local Package DTS which logged in as the user runs Dandy. But when Scheduled gives me this error: MESSAGES: The job failed. Unable to determine if the owner (XXXX\YYYY) of job Copy from 2005 to SQL 2000 Server has server access (reason: Could not obtain information about Wi...more >>

I have a data pump task in one package that uses a copy column transformation. I would also like to add this same transformation to another package. Is there any easy way to copy the transformation and place it in another package or am I stuck doing the mappings all over again? If it was ...more >>

Hi, I am using bcp and xp_cmdshell to produce output text file in sql server 2000. The size of the output file is so big. Is there any way to break the file into small files (for example 500 records per each file) ? Is there any option using the xp_cmdshell? Thanks, Aravind ...more >>

Hey. I've successfully migrated all the packages from server\instance1 to server1\instance1. I read in one of the articles I've to change MsDTSSrvr.ini.xml file to see the migrated packages in SSMS. I did it and now i see the packages. But how would I edit the package I've migrated from serv...more >>

Fellow SSISers: I have a fully working DTS package that runs an Execute Process task. The Execute Process task bcp's the output of a stored procedure as an XML file. When I try to translate the same functionality into an SSIS Execute Process task, the task fails. In DTS, the properties...more >>

I am using Integration services to move some data from an Oracle DB to a SQL2005 DB. When I run the package from my DEV machine everything works splendid, however when I deploy the package, the Oracle connection fails, with a NULL Password. I have tried DSN, OLEDB Connections. When I edit the ...more >>

I have read through many of these topic and still no luck with this: My situation is that I have a DTS package with a Execute SQL Task. The task executes a stored procedure which has one input and one output parameter: EXEC Update_SupplierParts @FileName, @Return = @Return OUTPUT My stored pr...more >>

Hi all, I am new to SQL-Server and Integration Services, so I hope it is a simple question for you. Here is what I do... I have a .csv-file and create a Flat File Source. I want to get the data into a SQL Server Destination and create a new table with the proposed SQL-Statement. Now I have...more >>

I am going to import the data which is required for creating reports. The data in the table is not easily queried, therefore I have created other tables to extract the data from this main table. As importing data would be a weekly procedure,I will have to overwrite the existing data with th...more >>

Hi, I want to set up DTSRun to be executed by some particular users so that they can update specific cubes on demand (e.g. when they have just added some journals and want to see the effect on account balances in their cube). I have got DTS running (using encrypted command line options) on...more >>

Hi, I have created a package to process Analysis Services (AS) databases. I am currently using variables to store info such as the Connection and the Initial Catalog (AS database) and these variables are loaded from a configuration files (stored in the SQL Server). I now want to call t...more >>

Dear all I'm trying to figure out how the slow changing dimension wizard works. I want to use it for a Datawarehouse for a Date Dimension. All attributes are changing attributes type 1. I expected to work it this way: 1) New rows: They are inserted with the new row task 2) Updated rows: ...more >>

DTS Package designer add success criteria I'm using the DTS Package designer to export data to a text file. But I only want to export/create a file, if there is data to export. ie if (select count(*) from xxx ) > 0 do export. How can I do this? ...more >>

We're having to install new SQL servers on a new naming convention. We know the changes we have to make on the applications that hit the SQL boxes. However, we are not sure what DTS or SQL Agent jobs would need to be changed. Is there a way that we can search the DTS & SQL Agent jobs for ...more >>

(Note: SSIS not DTS) Anytime I try to perform lookups for string columns, I never get a match unless the string takes up the maximum size. For example: Pipeline Value Lookup Value Result ========= ========= ===== THIS WORKS THIS WORKS Finds lookup value NOPE ...more >>

I have an input file that is fixed field except for the last column, which is variable length. A {CR}{LF} terminates each record at the point where it ends. The record does not end at the same column because the following spaces have been stripped from the last column. I do not a character that ...more >>

I have a DTS package that reads from a staging table. A series of SQL tasks update a number of tables in the database. The last step truncates the staging table, making it ready for new records. If this step (the truncate) fails I want all the updates performed by the preceeding SQL tasks r...more >>

I am having several problems. I first started to get a problem when applying servvice pack 3a to my existing sql server. When I was trying to execute activeX scripts it got the error "ActiveX scripting was not able to initialize the script execution engine". I figured the service packed screw...more >>

I am having an issue where I have some raw file source inputs and SSIS is expecting those files to exist at the time that the package is being designed, but they are being created during the process of the package execution. How do I make SSIS not care that the file is not there until packa...more >>

Is it possible to list multiple files in the Files property of the ForEach File enumerator? Example: *.txt;*.err Thanks! Brandon...more >>

I have a DTS package I am executing from Visual Basic. Everything works fine except the emails to tell me whether the files were appended successfully or not. Works fine in SQL. Should this work in VB? Is there anything additional that needs to be defined? If so, I'll dig some more, or should...more >>

For a DTS package; Copy SQL Server Objects Task Source, pick a database on server1 Destination, pick tempdb on server1 Copy (with these selections): Create destination object Drop destination objects first Include all dependant objects NOT Checked, Include extended properti...more >>

We recently installed SQL Server 2005 Service Pack 1, and now the SSIS Service times out whenever it tries to start. We've tried starting the service using local and domain accounts but nothing works. The service worked fine before the service pack. Any ideas? Thanks....more >>

I'm trying to pull data from a set of oracle tables (I've setup separate DTS packages to pull data from each of oracle tables I work with) but what I need to do is setup exclusive locks on those oracle tables whilst the DTS package is runing. I was wondering whether this is possible using DTS?...more >>

I'm executing DTS from asp with this code and hard coded user pwd in asp file it works just fine Dim objPkg, strError, iCount Set objPkg = Server.CreateObject("DTS.Package") const DTSSQLStgFlag_UseTrustedConnection = 256 objPkg.LoadFromSQLServer "server", "", "",DTSSQLStgF...more >>

Hello - My apologies if this has been posted on before, but in my searching around this evening I was unable to find anything even closely related. I am attempting to import an excel 97/2000 .xls file into a SQL database that has 1 particular field in the table of the DB that is not nullabl...more >>

I currently have SQL Server 2005 Integration Services for a general overview of SSIS and it is good for that, but I also need a book that deals specifically with scripting within SSIS (VB.Net). I saw The Rational Guide to Scripting SQL Server 2005 Integration Services, but it was for the Be...more >>

SQL 2005 SSIS This should be simple, but its not. I have a simple package that selects data from one server and inserts it into another. It works interactively but I cannot get it to run scheduled. I have tried changing the SQL Agent to my login and it fails. The only message that I get i...more >>

Hi, I have a package which load a flat file to a SQL server table and runs fine in SQL 2000. There is a column in the flatfile "orderdate" which has the data like '20060423', I load this column data to the 'Orderdate' column of the sql table which is the datatype 'datetime' . The sql 2...more >>

How do you undo a situation where all of a sudden when you attempt to double click on an ActiveX VBScript in a DTS package you can only see the Language Tab and the Browser Tab as full sized windows? I can no longer see the VBS Code Edit half of the window displayed although it appears to flas...more >>

SQL 2000 sp4 Does anyone know how to execute batch files simultaneously in DTS? For performance, I need 4 batch files to execute at the same time. NOT batch1, then batch2, then batch3 and finally batch4. All four must start at the same time. When they end is of no importance. Thanks in ad...more >>

This is what I need the DTS package to do: I need to create a temp table, import the contents of a text file, add some info to the temp table (done with stored procedures) and then add the contents of the temp table to the permanent table and drop the temp table. I created the DTS package in En...more >>

I CREATED A SIMPLE DTS PACKAGE TO UPLOAD AN TEXT FILE INTO A TABLE IN SQL SERVER DATABASE THEN SAVED THIS PACKAGE AS A VISUAL BASIC MODULE FILE. NEXT I CREATED A VB PROJECT AND ADDED THE ABOVE MODULE TO THE PROJECT AND RAN IT. THE PROJECT DID RAN TO THE END, AND DID NOT SHOW ANY ERROR MESSAGE,...more >>

Does anyone know of any good websites/resources that could help me figure out how to alter a DTS package's Transform Data Task's properties (specifically changing the destination table) using c#. Thanks ...more >>

Hello, I've an issue with a DTS. Here is the scenario: Server side: the DTS has two step: 1) Delete some row from some tables. 2) Imports data from Access DB into SQL-Server, using a ODBC entry (from a file) Client side : an winforms application has two step: 1) Copy local Access DB on...more >>

My project's "live" data is currently in an SQL 2000 database. I was running a development copy of SQL 2000 on my local development machine. When needed, I just used DTS to grab a current copy of the database tables including the table definitions and their current contents as well as the ...more >>

I have a number of OLAP cubes to be processed. There are a series of steps to process shared dimensions, then the cube-processing tasks. All the cube-processing tasks have workflow from last shared-dim task to execute "On Success", but there are no workflows set up among the cube tasks. They a...more >>

hi everybody, I have a hopefully easy problem to fix. I am trying to import a huge text file into a table with DTS. The problem is that every 200,000 lines or so, the file has a bunch of lines in it that are not data. There are about 5 lines that are some other information, and the headers are ...more >>

I want to know if the SSIS is in the SQL 2005 Express Edition?, and If so, where it is?. Javier Salvatierra...more >>

Was having a wonderful time with Integration Services until I uninstalled/re-installed SQL Server 2005. I now am unable to create or edeit e.g. DataFlow Tasks. Clicking on "Click here to add a new Data Flow task" in Data Flow pane gives the following error: ----------- TaskHost "{C3BF9DC...more >>

I would like to know how I can monitor the execution of an SSIS package that has been kicked off from a VB.Net component using the DTExec command. I did this in VB 6.0 using the reference to Microsoft DTS package object library and with the following code: For Each oStep In oPackage.Steps If...more >>

I have created a simple import job that first truncates three tables and then imports update data into those tables from an Access database. My problem is that the job fails on when running the SSIS import package. The import works when I create the package, but not from within the jop. I beli...more >>

I have a DTS package (sql 2000 sp4) that executes correctly when I run it from the DTS designer but fails when it is scheduled as a SQL Server Agent job. My sql agent and sql server services both run under my Windows account. The failing step is an execute process task that calls a .bat fi...more >>

This is driving me crazy. It appears when you try to select the Package Name for a Execute Package Task, the drop down list is populated by sp_enum_dtspackages. The problem is that this sorts by package ID and not by package name. There doesn't seem to be a way to modify sp_enum_dtspackages ...more >>

Are there any docs to explain how to export a table to CSV file? I can't get it to work. I have created the ODBC but I get an error that I can't modify my table because its in a read DB. Any help would be greatly appreciated. TIA, Joe ...more >>

I'm writing my first SSIS package and am running into some problems that I could use a hand with. i'm using a For Loop Container to do two things: 1) Use a FTP task to look for a file on a remote server 2) On Success use the Script Task to set a package variable to False so the loop...more >>

I want to create Transform Data Task with a VFP free table as the destination. The table is not in the dropdown selection. I know the table exists because I can see it in the folder. I am able to add an Execute SQL Task with the same VFP Connection and query the missing table. I get the exp...more >>

Hi, Please help. We have one sql server with two databases. One database is for training and the other is production. We currently have 400 Sql logins for training/testing and 400 for production. I want to create approx 40 new sql logins in production and copy-migrate them over to the trai...more >>