SQL 2000 on Server 2003 I've created 8 different DTS packages and scheduled them by right clicking on them. 6 of them work fine. However, 2 of them get the same error when the job is run (they run fine if I right click on the package and select 'Execute Package'). Here's the error: DTSRun: ...more >>

I'm using SSIS to bring fixed width files into the database. After the package runs the data has blank spaces at the end of it that need to be trimmed so "John Doe " would become "John Doe". What is the best way to trim the blanks when using a SSIS package to do the insert? Thanks, M...more >>

Instead of writing "Hello" I want it to read a value from a cell in the excel sheet I am running this from. The code is in VBA: Public Sub oCustomTask1_Trans_Sub3(ByVal oCustomTask1 As Object) Dim oTransformation As DTS.Transformation2 Dim oTransProps As DTS.Properties ...more >>

Hi, I am new to using DTS and just created my first DTS package that imports a text file into a table. The package works fine and now I have to add a trigger or equivalent that will do the following: 1. For each record where the member number doesn't already exist insert the record int...more >>

Hi, I have 20+ jobs running which loads and executes SSIS packages. The problem I am facing is that after few days they start to block each other and after removing blocking by looking into output by sp_who2 and "Select * from master..sysprocesses" they start working properly for few days. ...more >>

I am trying for the first time to create a job to start at a specific time to start a DTS package. What I need to put in the Type and Command when creating a job step. Or is there an easier method?...more >>

Hi I have recorded a DTS package in Enterprise manager. I paste the code into VBA. However I do not understand how the program works. I am trying to cutomise it. I think I can get around VB but how does the activeX scripts work in VB. When are they executed? ...more >>

Hello, Can I call a Script Task from Other Script Task? Actually, what I am trying to acheive is: I have a piece of code Like some Functions that I keep using over n over in all of my script task e.g. functions for Reading n Writing Package Variables and Instantiating some .Net Objects....more >>

I'm trying to transfer all records from Database A Table1 to Database B Table1 getting only the records that are not currently in Database B Table1. I have a primary key (Key1) that is in both. So basically if this primary key does not exist in Database B Table1 then import the record. How ...more >>

hi, I had to insert huge amount of data from one table to another. Im doing this 3-5 times a day and I had to do it in stored proc. In one insert Im copying 2-3 millions rows. I HAD to use stored proc. 1.Im selecting a recordset from 4 tables. 2.Insert them to a table. 3.Table has 2 columns....more >>

Hello I have a copy of a SQL Server 2005 Express database - the mdf and .ldf files. If I copy to my machine and in the Enterprise manager try to attach the files I get error 602 - and apparently you cannot do this as the database structure has changed so much. Bearing in mind SQL Server 20...more >>

How does one drop / close a connection from inside a SSIS .NET script task? I have a long running package (i.e. 12-18 hours) that extracts data from an Oracle Datawarehouse, and populates a data mart in SQL Server 2005. The Connection manager properties for the oracle connection has Re...more >>

I'm trying to map two source columns into one destination column but it won't work. Basically my source is a CSV file that has an Area Code field and a Phone field. I want to combine them into one field for the destination sql table of my DTS job but it won't take. 'The following doesn't wor...more >>

I have an odd problem I have been assigned to debug and am having no luck finding anything online that is even close. Maybe someone else has had this issue. We have a windows 2000 box on sp 1 with Windows 2000 sp 4. One of our developers discovered that every 3 weeks or so his dts packages ...more >>

Hi All, Is there any way that I can call a web service inside a Script task in SSIS package? I'm not able to add Web reference inside the script task :( I know a liitle abt the Web Service task, but I want to pass a XML Document as parameter to web service and the script task is creating th...more >>

Hi, what script will I use for the OnClick event of a button in an Access front-end to run a DTS package (on demand)? Many thanks Jonathan...more >>

Hi, how is it possible for me to export a DTS package so that I can send this example to another site so the administrator can use it? Many thanks Jonathan...more >>

Hi, I've been struggling with returning a day of week number. I want to return a 1 for Sunday and a 7 for Saturday. I thought this would be easy with a derived column task and using the DATEPART function with "dw" as the parameter. However I've found that this method is Language dependant, ...more >>

Hi, I am Calling a Web Service using SSIS Web Service Task, this web Service is accepting a dataset as a parameter. How do I pass a Dataset as a parameter to the Web Service usin Web Service task??? I am generating this Dataset by calling a .Net Code in the Script Task. Can I collect thi...more >>

In either 'control flow' or 'data flow' if I right click on the design surface and select variables, I am presented with a blank grey tab to the left. Is this meant to happen? Surely there should be something on the tab or is this minimalist development gone mad? ...more >>

After copying a task from another package, I am getting a validation error regarding a 'derived column' data flow component. The error is as follows Error 2 Validation error. Underlying updates: DTS.Pipeline: The package contains two objects with the duplicate name of "output column "Und...more >>

Newbie here, so please be patient. I am trying to import data into an SQL 2000 table from an ODBC source. If I use a program like WinSQL I can query the source database and get correct data just fine. But with DTS activex scripts, the transformation process returns incorrect values for ...more >>

I feel like I'm losing my mind. I can write code in 7 different = languages, but I can't figure out how to create an SSIS package to do = the following: Table A, 6 columns: EmpID, Code1, Code2, Code3, LocationCode, = ScriptPath Table B, 5 columns: Code1, Code2, Code3, LocationCode, ScriptPa...more >>

I need a way to execute a sql dts package when a file is placed into a directory. Essentially this would be like a file system Monitor or file listner that would be waiting for a file as soon as the file is in the directory it would read from the flat file and then execute a package ...more >>

I have the below code in an ActiveX Script task, but when it encounters a task that does not have the SourceConnectionID property, then it bombs out. So I need some way to either dynamicalky determine if that property exists on the task, or just get a collection of only Data Pump tasks. I'm no...more >>

Hi, Can u plz help me with the Compare n contrast betn these 2 codes for reading n writing Variables in Script Task. Code #1: i) Read Variable: Dim vars As Variables Dts.VariableDispenser.LockForRead(varName) Dts.VariableDispenser.GetVariables(vars...more >>