I have to identical tables in two different servers. I want to insert the rows from server A to server B, where these rows doesn't exist in B. For those who exist in B, I want to delete them from B before the insert and then insert them too. I managed to insert the rows but not to delete the r...more >>

I have folder called TEST and is located in C drive. Every month, a new file with the name IMMYY.txt will be put in there (MM---Month, YY---year). How can i create a SSIS package to check to see whether there is any new file in TEST folder and, if there is, insert into the filemonth field in...more >>

Hi, Does everyone know if there is command line to build a SSIS project equvilent to the build menu in the visual studio? Thanks,...more >>

I am trying to do something that took no time in SQL 2000, which appears to be way more complex in 2005. I have added a column to a table(attribute) and trying to push this table out to another server using DTS. Well, when I select the table in the table list, and go to "Edit Mappings", th...more >>

If I assign variable "LoopCount" in the ReadWriteVariables property of a Script Task, it should carry over to the Loop Container Scope afterwards right? Here are the steps I am using. 1. In Script Task 1, assign Dts.Variables("LoopCount").Value = 3 2. Assign variable "LoopCount" to R...more >>

Hi, under sql server 2000, do you know how I can access via vbscript to the dts code and make programmatically some changes ? what are the usefull api's ? for example, I want to change database properties of course, I can write the dts the correct way in order to handle different se...more >>

Number of articles on web showing how to implement breakpoints in SSIS =zillions Number of articles on web showing how to 'step into' =bugger all Am I being a bit thick? I'm used to hitting F11 to move on in VS.net It hits the breakpoint but then what? Either I can carry on running ...more >>

Hi All, I'm getting an environment ready to test SQL 2000 DTS packages running in SQL 2005 (under legacy..DTS). I will be calling these from VB code attached to an ASP.NET 2.0 app. Before investing too much time... 1) Is it possible to call DTS packages from .NET using SQL 2005? 2) If...more >>

Hello, I received this error when processing SSIS Package. Error: A deadlock was detected while trying to lock variables "User::LoopCount" for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out. I declared the following my variable also in the code belo...more >>

I've got a project to export data from a SQL Server and get it into a text file which has multiple records. Basically, the output file has a 3 records; a file record, a header record and a detail record. It has to be configured like below: File Record Header 1 Detail 1 ...more >>

I have a situation where I have a remote system that I need a File from. I have created a database link from the oracle system to sql server. When oracle generates the file it then writes a row to a indicatator table. I need to then execute a dts job to ftp the file from the remote server to sq...more >>

I have inherited a package and am struggling to get it working. It is failing at the point of trying to open an XLS. I have tested the connection and am able to preview the data ok. (I am running in BIDS/VS.NET) When I try executing the task I receive the following error: Error: 0xC020801...more >>

i am writing DTS in sql server 2000. i have to write the delay, such as delay for 1 minutes before taking to next step. i have to use WScript.sleep (60000) to do the delay, but it prompted the error. Object required: 'Wscript' so how to do the delay in sql server 2000 DTS?? ...more >>

Hi, Can I hv filters for Multiple Files in the ForEach - File Enumerator of SSIS. Basically, what I am trying to do is I am Looping thro a Directory for 2 Kinds of CSV Files one has extn '.add' n the other has extn '.upd'. Now if I try to include filter for both of these files by specifying...more >>

Can anyone tell me if there is any significant difference in speed using drop and recreate table vrs delete rows in existing table on a table with a large number of records? ...more >>

Hi! I used sql server 2005 to emigrate a dts from 2000. But I cannot to see the dts in 2005. SQL Server 2005 said the migration was successfully. Why I can't see the DTS in SQL Server 2005.? Thanks, Freddie ...more >>

hi, i have several dts packages from an old sql 2000 install that i upgraded to sql 2005, if i install the client tools on windows 2000, then install the additional DTS components i can open the old DTS packages sucessfully, if i install the client tools and the dts components on a window...more >>

I've created a number of DTS procedures using the Business Int. Dev. Studio, and can view these in the Server Management Studio Object Explorer (Integration Services – Stored Packages – MSDB). However when I try to access these from VB.NET 2005 as follows; Dim oPkg As DTS.Package2 ...more >>

It seems I can do the type conversion in two place: 1. The advanced editor for flat file source => Input and output properties. And I can set the output columns data type properties there. 2. Using a Data conversion box in Data flow transformation. Any difference between these two? Which ...more >>

I want to move SQL Server 2005 data from server1 to server2 using SSIS. (1) If I run the SSIS package on server3, will that take longer than if I run it from server1 or server2 ? (2) If I run the SSIS package on server3, will the data have to go via server3 on its way from server1 to serv...more >>

(SQL Server 2005 Dev on Windows XP Pro SP2) When I use a script transformation to put data into a DT_IMAGE column, my package hangs. It doesn't seem to matter what data I write, so I was able to reduce the non-working example to this: Public Overrides Sub Input0_ProcessInputRow(ByVal R...more >>

Hi there, I have a simple Data Flow Task in my package (amongst other things) that simply copies data from a staging table to an archive table. The archive table is a copy of the staging table (at the moment, including the clustered primary key). Copying across 36,000 rows has literally ta...more >>

Hi there, I was wondering whether it is possible to return a recordset and then filter it when using it in an ADO ForEach container? So rather than using 2 recordset objects which hold similar datasets with different WHERE clauses and sending these to two separate ForEach ADO containers, can y...more >>

Hello, I'm wondering if it's possible to somehow dynamically obtain the name the task that was run previous to the current task. The reason I ask is that I'm hoping to create a single "Execute SQL Task", that logs errors to a table via a stored procedure. If I were able to obtain the name...more >>

I have been working on recreating a dts package in ssis for 2 weeks. It is ridiculous. I finally got sql server 2005 to run the package successfully. With half my hair left, I realized the package does not update the flat file destination. The destination is a .dat file in a directory off the c driv...more >>

Hi, I am building a DTS package in Sql Server 2000. Data source is an excel file and destination is Sql Server 2000. This package runs monthly and loads the data into database. But evey month the number of columns in the source excel change. Now i am trying to get the number of columns from the...more >>

I have developed my DTS into separate packages. Is there any way to bring all these sub packages together to create the final package??? Thanks in advance for your help. wnfisba...more >>

I am executing my 2000 DTS packages in 2005 and I am getting the following error message: could not find stored procedure 'master.dbo.xp_smtp_sendmail'. Every other steps worked fine. Thanks, Emma...more >>

I have dtsx files and I want to save it on SQL server. How to do it? Thanks....more >>

Greetings and Salutations All, I am new to SSIS and am building a package that will take a denormailized flat file and move its pieces to a SQL Server 2005 DB. I have used the flat source in numerous earlier data flow (df) steps with no trouble, column 11 is checked off for all the previou...more >>

Hello, I'm in the beginning phases of rewriting a simple DTS package under SQL 2000 to SSIS under SQL 2005. My simple package today does the following: 1) Pulls a file down to C:\TEMP via FTP 2) Contains 15 Transformation Tasks (Groups) where each task is reading a date, time, group, an...more >>

Let me begin by saying my script runs perfectly from Windows. It fails within an ActiveX task on DTS run interactively from my workstation via Enterprise Manager: Set objConnection = CreateObject("ADODB.Connection") Set objRecordSet = CreateObject("ADODB.Recordset") Set objFS = Crea...more >>

Hi, I 've got a DTS package that imports a comma delimited text file. It started erroring out and I discovered that at the end of the file, there is a blank row, basically an extra carriage return. Is there a way to get the package to ignore the last line if it's a blank row? I don't know h...more >>

Hi. I need some help figuring out how to pass a user variable into an Execute SQL Task. I have a user variable counter that I am using in a for loop container Variable Information Name Scope Data Type Value Counter Package Int32 1 For Loop Container InitExpression @Counter = 1 E...more >>

Hi, I've posted this question to the datawarehouse group, but thought I'd post here as well.... I'm just getting my feet wet with SSIS, and I'm having some trouble with the Slowly Changing Dimension transformation. I'm processing Type 2 SCDs, and in addition to creating a new current dimensi...more >>

Hi: I know I can fairly easily import XML files into SSIS, but what is the best way using DTS--I'm pretty sure there are a few ways using scripting etc. Thanks, Kayda ...more >>

Hello, In my Data Flow Task, I have a Flat File source that I would like to use a variable. How do I accomplish that? I tried it in Advanced Editor & Connection Managers, but not sure where I could slide my variables for it to be recognized. Any help is appreciated, -Lawrence ...more >>

I have created a dts package (to simplify) with 2 steps 1) open an excel file & run a macro 2) send an email that the job ran. step 2 is dependent on step 1. I have step 1 set up via a batch file which opens excel & the specific excel file (which contains a macro which runs automatically...more >>

I am using SQL Enterprise Manager installed on my desktop to access a variety of SQL servers. The problem occurs on all the servers I connect to. We are on SQL 2000 although I wouldn't think that was pertinent. I was trying to change the table name on a DTS. The problem is that, when I t...more >>

My source connection is a SQL Server in SSIS and I use SQL Authentication. So I provide the user id and password in the source connection. When I check the object into Source safe and check it out, tha password is not saved. This was never a problem in the DTS world. Also, I dont want to give ...more >>

Hi, I'm exporting data from sql server 2005 to oracle 10g using the 2005 Management Studio. Source = sql server native client, dest = MS OLE DB provider for Oracle. In order for this to work properly, I create the destination oracle tables using an oracle script (I've done it many times on ...more >>

Hi, Sorry i'm a bit of a newbie with SQL. I'm using a Oracle linked server. When I use a openquery in the query analyse i get the desired results. When I try to use a 'View' in Enterprise Manager the gives the correct reults but when I try to save it I get: ODBC error: [Microsoft][ODB...more >>

I had several jobs scheduled to copy databases from a live instance to a development instance both running on the same server. On installing SP2, the jobs now fail with the error below. The packages referenced by the jobs are executed successfully using Visual Studio or the Management Studi...more >>

Hi all, I have developed a DTS package that saves the result of a query into a text file. I have choosed the file name using browser. The result is saved in a path (c:\result.txt) and the DTS is scheduled to run daily midnight. I want to generate the file name with current date as suff...more >>

Hi! I've recently migrated my db to Sql Server 2005. With Sql Server 2000 I could easily execute my DTS packages from an Excel's macro exploiting the following VBA code: Dim dtsp As New DTS.Package dtsp.LoadFromSQLServer _ ServerName:="Server_Name", _ ServerUserName:="sa", _...more >>

Any assistance is apprecaited. If there is any document, that would be great! Thanks! Peter -- good good good not too good bad bad bad not too bad...more >>

Pretty new to SSIS. I have a Table with columns containing OldFileName and NewFileName. I have created Variables called OldFile and NewFile. I thought I should use the File System Task to go to Directory then I want to Loop through each file and replace the filename with the result of a ...more >>

Hi, I'm using SQL Server 2000 to design DTS packages. Sometimes when I open a database in DTS Designer I can't see the full table name in the "Source" Tab - "Table/View" field and "Destination" Tab's "Table name:" field. This is really annoyed me as I have to guess the table name!!!. Could an...more >>

I have set... Imports System.Xml But it says type xmltextwriter is not defined. Anyone know why ? Thanks ...more >>

I have two products say X and Y. Both run on SQL Server. X is used to manage clients, client orders and payments. Y is used for fulfilment of these orders along with the client information and dispatch addresses. I have been given the job to integrate these two products so that the customer pe...more >>