What I'm trying to achieve is a SSIS package that will pick up 1 or mor excel files, process the data in them via the conditional splitter pushing the good data into a table, and all other rows into an erro table. I'm having some issues using the ForEach container to process multipl excel sp...more >>

On what type of global variable in DTS can I store a timestamp (varbinary(8)) value? Thank you in advance. ...more >>

From my brief experience with SSIS, I gather that packages are meant to execute, perform the job, and end. I'm currently using the SQL Server Agent to kick off my package on an interval, however I would like to be able to run my package in a real time manner to process data as it comes in, po...more >>

I have a DTS package in Sql 2000 where I select records from a table and then place them into an Excel table and email that to the users. If there are no records, I don't want to email the users anything but I do want the administrator to know that no records existed. So, is there a way th...more >>

I have a bunch of very basic DTS packages that I am converting to SSIS. They simply truncate a table in the destination Db, then copy all rows from the source. They run fine as DTS packages. When I re-design them in SSIS and run them, I get an error stating: "Cannot insert the value NULL in...more >>

Hi all I have several data driven query tasks in the DTS I am working on. I have only one type of query but which has to UPDATE more than one table and I am not finding the way to do it nor I have found information in the web. How do I update more than one table in the same query? Thanks in ...more >>

I am importing a .txt file into a database using a DTS package. I've been successful with this before but the file I have now is from IBM mainframe and the dollar fields are packed. Is there a way in transformations to unpack numeric fields?...more >>

I have a SSIS package that was migrated from a DTS package. If I rightclick on the package & click run package within management studio, it executes correctly. If I run the package in a stored procedure using DTEXEC utility I get the following error: Description: Failed to decrypt protect...more >>

Hello, does anybody have a sollution for the next problem : 1) I have 1 query which gives me next out put : No. list 1 2025 2 3000 2) Other query gives me next out put : List item descr. 2025 10 descr1 2025 30 descr2 2025 25 descr...more >>

Hi Is it possible to activate or deactivate a scheduled DTS job with a t-sql script? Thanks for some thoughts Michel ...more >>

Can I define a step to be always executed as the last step of a package? I want to log the error status of each other step in a database table. I know that the package itself looks at the final status of all the steps at the end and issues a message for each failure, but I want to write the sa...more >>

I'm using DTS to process a text file in SQL Server and then exporting it back out as a text file. I first create a table in SQL Server, then import the text file into that table. I need the file in its orginal sequence as it goes in and out of the SEQ Server. However, sometimes, the file is ...more >>

I have a job that kicks off a stored procedure. The proc in turn kicks off 25 DTS packages with scripts like execute master.dbo.xp_cmdshell 'dtsrun /Smtcntsql02 /NNavision_TT_Vendor /E' for a while, we were using the /U and /P switches with the sa account and password. The packages still ...more >>

Is there a way to load a package from a structured file, in a different server than the one it was saved from, and then save it back to the same structured file as a new version under the same package ID? When I save a package to a DTS file, it has a package ID and each save from the same ...more >>

I created a package with is used several times in another package. Because of the number of times I changed the subordinate package, the file size grew quite large. To reduce it, I called up the subordinate package and did a save as newfilename (with the same package name). I then deleted t...more >>

I know DTS but am new to SSIS. I am having trouble exporting records that don't match from a lookup transformation. I get the following error: Row yielded no match during lookup. I would really like to have a list of all records that did not match so that I could export and examine it. ...more >>

“GiUpdateRowCount” Global Variable Created DTS package Update TableName From TableName2 Where TableName.Col1 = TableName2.Col1 SELECT @@Rowcount AS UpdateRowCount Above Query is used in Execute SQL Task Once I execute the Execute SQL Task, UpdateRowCount value should pass to Gl...more >>

whats the best way to identify whether dts is currently running or not?(ms-sql 2000) Cheers DF ...more >>

When I execute the package manually (right click on the file, Open With | Execute Package Utility), the package executes normally until it reaches a line 'Information: Execute phase beginning'. At which point it seems like processing stops (no other messages). I'm receiving this err...more >>

I would like to create a DTS package that will import a password protected excel file into SQL. But I get get an unable to decrypt the file error when I try to link it to either a file dsn, or system connection. Does anybody have any ideas on how this can be accomplished. It should be simp...more >>

I am going to have a stored procedure that will call and execute an SSIS package. I was going to use the DTexec utilility but have not found out how to call that utility from a stored procedure. Is the the right approach or is there a better way? Is there an alternate way to call an SSIS package...more >>

I have a large table and i am trying to find a way to import only the new records into SQL Server 2000. Once the records are in the table they are not updated so i can use the date and time fields to find what is the most recent record that is not a problem. The problem is how do i use the DTS...more >>

ok simple question and maybe i don't even need the template. How do you create a new dts package in 2005 Note: I have VS2005 pro as well as sql 2005 when i goto Sql server business intelegence studio VS pro starts but no DTS (Data Transformation Project) template -- thanks (as always)...more >>

I am rather new to DTS, I apologize if this has already been covered elswhere in the group - I couldn't find it. I am trying to create a package to transfer an arbitrary number of tables from one database to another on the same server. The criteria is to transfer all user tables with names begi...more >>

Hi all, Maybe my doubt is very simple, but i did't find references how to solve this problem that in SQL 2000 I've used dynamic properties. The objective is to create a text file destination based in a query. But each time that the package runs I want to create a file based on the actual dat...more >>

we are using SQL Server SP 4 on W2003 box. we have a source database otr and a destination newbus we currently read from the source and insert into destination. now we want to limit what we query from the source by joining it in a table in destination. is this possible. how can i se...more >>

We have a DTS package that refreshes our external website data on a nightly basis. I recently moved our external website off of our domain. The SQL Services were previously running as DOMAIN\Administrator account. When I moved the server off of the domain, I reinstalled SQL Server and set the...more >>

I am new to DTS development. Can you please tell me the easiest way to create a package that will create tables each month that will be the same except for the month name. What I am trying to do is copy data from existing tables into archival tables each month. i.e. In May - copy data from...more >>

Hi I had a previous question and I have to clarify. I am using an Access 2002 Project that is CONNECTED TO A CURRENT VERSION OF MSDE (NOT SQL Server Espress). I was wondering if anyone new if it was possible to restore a Database that was Backed up by SQL Server 2000 developer edition, ...more >>

I set up a workflow in DTS to execute an SQL task when a previous SQL task fails which worked successfully. I then set up an SQL task to run when a previous package fails. The package loads data from Access to SQL Server. I removed the table it loads from Access to get it to fail, however ...more >>

Good afternoon to all! I am starting to work with DW and SQL 2000 together with Analysis Server and am needing to know if it is possible and as to make to track a flow of dts to be able to identify, when to give problem, in which stage occurred the problem. Thanks! ...more >>

Hi I was wondering if anyone new if it was possible to restore a Database that was Backed up by SQL Server 2000 developer edition, into an Access 2002 Project. I have been told that it was possible and one of the responses I got was: 'What you need to do is specify a new file location f...more >>

I have two DBs and I have created a DTS package to import data from one to another DB and I have saved it in SQL (Data Transformation Services --> Local Packages). Is there any way to execute it from Query Analyzer? Thanks Dimitris ...more >>

I'm having a problem using the Foreach Loop container that contains an XML Task followed by a data flow task. When I run my package in the debugger, the XML Task fails with the following errors: [XML Task] Error: An error occurred with the following error message: "Data at the root level i...more >>

I am loading a DTS from a local file, setting the DTS parameters, and the executing the DTS. When I call Execute on the package it gives me "Type mismatch" for DTSStep_DTSDynamicPropertiesTask_1 If I run the package manually from Enterprise Manager, then it completes succesffully. If I r...more >>

I'm trying to import data from an Access database to a SQL Server database. I am using SQL Server 2005 Integration Services. The tables already exist in the SQL server database. I am having trouble with converting the memo fields (unicode text) to the varchar fields in SQL Server. How can I ...more >>

Is it possible to send or copy to a writtable CD-ROM drive? I have a customer in a remote location that is running a completely disconnected (from the internet) environment. They gather data and then need to get it back to the real world. The easiest way for them to do it is to copy the dat...more >>

I am running a DTSPackage in dotnet using the COM Microsoft DTSPackage object. I believe I can log results to the NT log, but is there any way to give immediate status to the user of errors? What would be great is to show the number of rows that are being copied using the COM object. Is this...more >>

I created a DTS package scheduled job through DTS Import/Export Wizard in SQL Server 2000 SP4. scheduled to run every 10 min (copy tables from DB1 to DB2 on the same SQL server). It ran Ok 1st time, but failed on the 2nd and the rest of them. I log on as sa to create the job. (see below) T...more >>

SQL Server 2000 3a DB2 Client tools version 7.2 I have a DTS package created by someone else. It has a transformation where a Mainframe db2 database is the source. I have an odbc connection set up. The destination is a sql server 2000 table. When I attempt to open the transformation ba...more >>

Hi Can somenone help me build a DTS in SQL Server 2000 that allows to schedule the execution of a executable file in a remote server?... [] Ricky ...more >>

Greetings SSIS gurus Using Sql Server 2005 on a Win2003 (sp1) Ent server. Starting on an SSIS project to move data directly from Informix tables to Sql Server 2005 via an ODBC connector. Successfully created an SSIS .dtsx to move the contents of a small from Informix look-up...more >>

I have been having a major problem scheduling my SSIS packages under SQL Agent. I have created a credential, a database logon with full access to MSDB and a proxy for these accounts to launch the packages. This is the same domain account that creates the packages. The packages are loaded on SQ...more >>

Hello there I have dts package that needs to create new excel file and import data from query to it. the name of the new file is name of report and date/time stamp. the name of the files is being saved in activeX and send into the destination connection How can i give order on dts packag...more >>

I am setting options dynamically for DTS for a SQL Server connection, and I am not sure how to set it for SQL Server authentication. What do I use in place of the last 2 lines? Set oConnection = oPKG.Connections("Destination") oConnection.DataSource = DestinationServerName oConnection.C...more >>

I am using the looping code by Allen Mitchell. The web link is below. http://www.sqldts.com/default.aspx?246 I had a package running last night to load multiple files. It was working beautifully. It uses the filesystem object to get all the files loaded, then archives to another folder when...more >>

Hello, I have an SSIS package/job that spins through a directory of files (a Foreach loop, which has new files daily) and for each file does a Data Flow task (call it "Step A") that inserts data to a database. I am trying to add a condition within the Foreach (daily file) loop that bypasses ...more >>

I am importing a table from a mySQL Database. The Database Column is defined as a numeric(6,2). I am receiving an error the the column is too wide for the import, the only value I can see in 18 rows (small table) is 22500.00. I have tried changing the size where I can, it doesn't seem to work....more >>

My question relates to connections in SQL Server 2000 SP3 I have a number of unused connections in my DTS package, some of which are causing problems (packages to fail and Enterprise Manager to crash). I have removed all references to these connections (in SQL tasks, for example) and removed a...more >>

Hi I'm creating a DTS Package that will move data (insert) from a SQL Server table into a DB2 (AS400) table. I'm using a data driven query, in the source I'm selecting a local sql server table, the destination is the db2 (AS400) table (connected via ODBC). The transformation is the autogenera...more >>