Is there a table that hold all the English information for all the connections,steps and tasks in a DTS job? in a DTS job's GUI Disconected Edits there are connections, that have datasorces. there are tasks that show file locations either for importing a file or the destination for exporti...more >>

Hi All, I have XML file which need to be loaded into database table using SSIS. Thank you for your response. Regards Tami ...more >>

What is the key property that must be set in order to get the Pivot transformation to aggregate rows rather than just display the same detail as the input with lots of nulls in the output? I want to create a pivot table that has the row headers showing Make of car, column headers showing th...more >>

I got the following sequence of tasks in my dts package : .... -> Script Task -SUCCESS-> Task 1 -> Task 2 -> Task 3 -> ... -FAILURE-> Task 3 So, if the script task succeeds, tasks 1, 2 and 3 are executed. If it fails, only task 3 is executed. The packa...more >>

I have to load text data from an Oracle 9i database into a SQL Server database. The Oracle database's language is defined as UTF-8, and includes far-Eastern language characters (Korean, Chinese etc). In my DTS package the Oracle database connection is "Microsoft ODBC Driver for Oracle". The Tran...more >>

After intensive search, i could only found transferring dts.sysdtspackages system table entry could transfer dts from one server to another... Currently i face 2 main questions: 1. After those packages transferred, connection setting still pointing to old server ( some are sql , some are u...more >>

Hello, I will be outputting the contents of a table to a file. I would like to log, in a table, the status (failed/success) of each row. Each row has a column with a unique number in it. This is the value I would like to output to the logging table, along with the success or failure message...more >>

At the moment we have SQL Server 2000 and use DTS to collect data from remote PCs. These remote PCs connect to our server, load the DTS package locally and then run the package locally. This is possible because that all have MSDE installed (which includes DTS.dll). We are planning on upgrad...more >>

Hi, We have a requirement to use XSLT to transform data into flat text before loading it into SQL. We use a function to strip funny chars out of the file. If we retain the function within the XSLT it works fine, but if we include it as a separate text file (either locally or on our web server) ...more >>

I have developed a SSIS package on my Client Machine which imports an Excel sheet. I have it working fine on my client. When I move it to the SQL Server 2005 machine in Development and run the package I get a column data type issue on a Field that the data type was a text stream on my CLient P...more >>

Hi, I have upgraded to SQL Server 2005. I have migrated all of my old DTS's to the new server. I would like to run the DTS packages in their current state before migrating them to SSIS packages. I am having a problem when running the DTS packages on the server. When it gets to the Active...more >>

Hi all, This is my first time posting, as well as my first time using DTS. I find myself in a bit of a quandary. I'm trying to import data from a flatfile into a SQL database, using the ActiveX VBscript engine. I want the fields which are nothing but spaces to be true 'null' values in SQL. I'm...more >>

Hi, Is there any way to give the destination file a new file name (i.e. one based on current date/time) in the DTS package or is it best to just write a DOS batch file to copy the file to a new filename after the package is run? Thanks!...more >>

Hi, How do you return a value from SQL task in DTS? I have a scenario which goes like this 1) I have a stored procedure (refer below) CREATE procedure AAA_DTS_LoadStudentTemplate --(@InConnection varchar (255)) @server_name varchar(20), @pkg_name varchar(20), @check int output ...more >>

Hello everyone, Newbie with DTS here. I am trying to port in a flatfile with the following format, abc|123^456^789|testing1 def|333^444^789|testing2 hij|444^^789|testing3 I am able to use the build-in GUI feature to set the delimiter to {|} however, I would like to see some activeX scr...more >>

Hi, I'm able to create a connection manager in ssis for an ODBC datasource. However I don't see anyway to use it as a source or desitination in a data flow task. Am I missing something obvious here? Thanks in advance....more >>

I'm a bit confused about "Protect Sensitive With Password" ssis package protection level. If I try to open the .dtsx in bids and hit cancel when it prompts me for the password, the package opens just fine. Same if I try to execute it on the server and just hit cancel when it asks for the passw...more >>

Does anyone know why I can't see existing packages on the server when I save a copy of a package to a server in bids? I can see the folders but not the packages. Is this a security feature or a bug? ...more >>

Hi, Wondering what happens to a SQL 2000 DTS Package on a SQL 2000 production server if it's migrated to SSIS on a SQL 2005 TEST Server. Will the DTS package still work/be on the SQL 2000 production Server?...more >>

I have an Excel spreadsheet that contains a history of football games which is in this format: Year | Week | Team | Away/Home | Various stats for each team. 1992 1 NO A 1992 1 PHI H 1992 1 DET A 1992 1 ...more >>

I put in my SSIS package a VB Script Task. When I run the package from Visual Studio on my pc then I have no problems. When I put the package into the SQL-Server 2005 (on another pc) and run the package I get the error: The task ... cannot run on this edition of integration services. It require...more >>

I am modifying rows of table via a script: OLEDB source --> Script Component --> OLE DB Destination (same as source) I am getting correct functionalty. My problem is that the transformed rows are appended to the original table. Desired functionality is to just modify the rows, not append...more >>

Hi All, In SQL Server 2000 DTS, I had an Active X script that, using ADO, performed the following basic operation: Retrieve a list of account numbers through Recordset1 While Not Recordset1.eof Build a sql statement based on fields from current row of Recordset1 Open Records...more >>

I have created a small ActiveX script which can load multiple DTS packages from the File System up to a SQL 2000 Server. The script works just great when executed as an ActiveX script in a DTS package like so; Dim fso, f, f1, fc Dim s Set fso = CreateObject("Scripting.FileSystemObject...more >>

Hi I have the following error in BIDS when editing a SSIS package. Error loading xxxxxxxx.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. I have one connection and this connection works ok. I deleted a...more >>

Does SSIS FTP Remote File Delete work, or does it have a bug? I have tried a very simple task both with file name explicitly specified, and in a variable and it errors with "Unable to delete remote files using FTP Connection Manager." Books Online suggests I should be able to delete remote fi...more >>