Why does tempdb grow when I am loading to a userdb (ole destination)? If this is transaction info, why would it even use tempdb & not log file of user db?? ...more >>

(DT_BOOL) SUBSTRING(@USER::_DataFile,(DT_I4) LEN(@USER::_DataFile)-1,1))==0 ? 1:0 Let me state what I'm trying to do, I have to do a restore from a backup, I want to append a 0 to the end of the data and log file names, then when I do it the next day I want to append a 1, because it takes ab...more >>

Hi All - I need to load a sql (2000 for now) db back from .NET code, should I still use the DTS objects to perform this task, or is there something "newer" in ..NET 2.0 that i can leverage? Thanks in advance! Derrick ...more >>

I am currently invoolved i8n upgrading our VB6 applications to VB 2005 and .Net. It would help us greatly to have a DTS PIA for SQL Server 2000. As far as I can tell from MSDN, there is no PIA for DTS on SQL Server 2000. Does anyone know of a DTS PIA for 2000? ...more >>

Hi, I've got an Event handler that catches exceptions. That works perfectly and it also sends emails to warn of the failure. Now what I would like to do is instead of emailing on every failure, I would like to re-start the package and send an email only if the package has failed 3 times. I ...more >>

I am trying to read a text file from an SSIS script task. I've seen a few examples of how to do this on the web but cannot set up my script environment to work. Specifically, all the examples I use have the Inherits UserComponent statement, which gives me a 'type UserComponent is not defined'...more >>

Any Microsoft guys out there? I posted this up yesterday and haven't got any response other than others having problems too. I'm trying to use the SCD on the Employee table for one of the bigger companies in the US. It works fine with small data loads but when I push the 100k employee feed ...more >>

Hi, Can a Look-up be made 'global' to an entire package? I have a Data Driven Query (DDQ), built using DTS designer and it has Lookup1. In the same package, I have another DDQ and it also needs the functionality of this look-up. How can I make this look-up (or it's functionality) glob...more >>

Using SSIS, I want to store my configuration in a database table. I opened Package Configuration Wizard, and selected Configuration Type: SQL Server, Configuration location is stored in an environment variable. Next I created an environment variable SSIS1_CONFIG For integrated security, ser...more >>

Hello: I have created a DTS packages and added an administrative and regular password on one server--they are now going to be migrated to production. Problem is, as a consultant in this environment I don't have access to the production servers so I can't migrate myself. The customer wants to ...more >>

Over the last several months, I have seen a handful of DTS packages fail with the error "Login (loginname) does not exist". The logins do exist and the password are valid. I can connect to the database using the same credentials and I can create a new DTS package that will successfully execute...more >>

Hi All, I have the following problem. I'd like to export data to 4 Excel tables the source of which is a ##temp table. It works fine with the first connection to Excel, but the rest does not see the ##temp table, I receive 'Invalid object name' error message. Have you got any idea what I ...more >>

I have a pretty standard SCD that misbehaves when using pushing large recordsets through it. I always seems to pass on a small percent of the 100k record set to "New Records" output even though the incoming record is identical to the existing record (no changes). I'll admit this is my first ru...more >>

Q1: What is the differences between green and red connections between objects in Data Flow tab in SSIS project? Q2: In Flat File Connection Manager --> New Button --> header row delimiter --> what is meant by {CR}-{LF}? Thanks alot, Bishoy...more >>

I have a couple of questions about SSIS Best Practices. For example, what is the most efficient way to synchronize SSIS packages across 3 servers? The package was originally identical in 3 different servers and I want to keep the changes identical. Also, how well does SSIS integrate with Visu...more >>

I have a couple of questions about SSIS Best Practices. For example, what is the most efficient way to synchronize SSIS packages across 3 servers? The package was originally identical in 3 different servers and I want to keep the changes identical. Also, how well does SSIS integrate with Visu...more >>

I am running an SSIS job from a VB.NET application by calling sp_start_job. The return value I get is only whether or not it was able to start the SSIS job. It does not tell me when the SSIS job actually completed (if it did). Is there a way to keep the job connection open and monitor the p...more >>

Hi, I have a SSIS package with sql command for SQL server 2005 and VS2005. First, I create a database in the database Master using the commande USE [master] then I had tables in that new database using the commande USE [new database] and the command USE does'nt work any more. All the tables ar...more >>

Hi, I have a SSIS package with sql command for SQL server 2005 and VS2005. First, I create a database in the database Master using the commande USE [master] then I had tables in that new database using the commande USE [new database] and the command USE does'nt work any more. All the tables ar...more >>

I receive the following error when trying to run the following vbscript via an ActiveX Task in SSIS: Error: 0xC0048006 at Run Enterprise Need SP Upgrade, ActiveX Script Task: Retrieving the file name for a component failed with error code 0x0485ACF4. The script: Sub Main() On Error R...more >>

I need to reference the Microsoft WMI Scripting Library in a Script Task. When I select Add Reference it only shows .NET references to add. Is it possible to use COM libraries/components, specifically WbemScripting, inside of a SSIS Script Task? Thanks -- Adam S...more >>

This may be the bonehead question of the year, but I do not see an option when using DTS to connect to an ODBC data source. ( MySQL in this case ) Can you do this and if so how?...more >>

I have created a DTS Package & scheduled a job for the same to run. But due to authentication problems the job is failing. Now i want to create a script from the package that i created. Can anyone suggest how do i go about creating a script from the DTS package???????...more >>

Hi, I am running some DTS via batch commands (Mycommands.bat) like this: dtsrun /SOBAG-SERVER /Usa /Pxxxx /NDTS__CTMKAP1 At the end, I want to stop and restart the SQL Server. How can I do this? Thanks, Hubert Retif ...more >>

Hi, I found a lot of doc regarding "Best practices...coding in TSql, Indexing, tuning diskss.......etc on microsoft web site and other urls. Is there somewhere some Best practices documentation to hand out for a newbie SSIS. What I mean, is something like Architecturel best ways/components...more >>

Hi All, I need to export data into Excel files and the headings have to be nicely formatted. I can't use a pre-formatted template because the new rows inherit the headers properties. Can any one suggest a workaround? Many thanks. Kolos...more >>

Hello, Does anyone have an example as to how I could take the entire contents of one text file, and append those contents to the content of another text file? I was planning on using a Script Task in SQL Server 2000 DTS. Thank you for your help! cdun2...more >>

I have an access database which has about 500 records with all data stored in just one table. I want to transfer the data to a sql database that has multiple tables. Each of the tables in SQL requires an ID field for the record. The access table doesn't have these fields. Is there any way to...more >>