I want to be able to edit a DTS package from the SQL 2005 client tools. It says that I need to download a web package to do this call "SQL Server 2000 DTS Designer Components" but I can't find it anywhere. Does anyone know its download address. ...more >>

Hi I have a complete format excel file which needs to be mapped to a Sql server 2000 table. I am looking different options currently available. It looks as if DTS does not have enough functionality. What it basically offers is direct mapping to table. I would like to split a cell into multipl...more >>

I'm new to SQL DTS services. Am trying to build a test data warehouse on SQL Server 2005 and I have 4 dimensions and a fact table. The dimensions contain auto generated keys. In the fact table, there's a single field that depends on the combination of the foreign keys that come from the dimensio...more >>

Hi: I need to loop through a connection setting the DSN Name, User, Password of an ODBC connection to Sybase each time to something different. I know how do do looping in DTS using ActiveX script tasks. In the object model for DTS it looks like the "connection" object only applies to OLE DB...more >>

I have 3 Self-Referenced Table with the same structure (Subj_ID,Parent_ID, SubjText, Notes) with the child/Parent relation between Subj_ID, Parent_ID. subj_ID in all tables starting from 1, Now i need to merge my 3 tables in one table without lose or destroy the child/parent relation. Is t...more >>

Hi all, I have a DTS package that copies files from one server, imports some data into SQL tables. The first step copies files into the server the second step opens an Access MDB and runs some queries. Is there a way to see where the DTS package is while it is running? I started a trace...more >>

I'm trying to use the SSIS "OleDB Data Source" object to create a connection to our Informix DB. I'm not having any luck. I'm totally unsure about how to translate our working connection string parameters into SSIS OleDB Object properties. Any help would be greatly appreciated ... Thanks in...more >>

Greetings, I'm trying to set up a SSIS package that will use columns from a flat file and insert them into an existing table using an 'insert stored proc' for the target table. I keep getting an error that says I have to provide inputs for all the stored proc parameters but the flat file only...more >>

Greetings, Anyone know how to set icon in c# custom task? project->properties->Aplication icon does not work! tnx ...more >>

I am having problems with the XML result set type in the Execute SQL Task. When I run the package in debug mode my string variable containing the result reads as follows: <ROOT><?MSSQLError HResult=3D"0x80004005" Source=3D"Microsoft XML Extensions to SQL Server" Description=3D"No description ...more >>

Hi: I am not going to creating the install shield, but I need to find out for the developer how to create a .dts package during an install routine (actually take an existing package .dts file and create it on the SQL Server the install is being run on). You would have to use DMO for this, rig...more >>

Hi All, I need to use SSIS to load Excel data into MS SQL server tables. There are multiple Excel files and each of them may or may not have multiple sheets. The schema of each file/sheets is the same and the data is loaded to a single table. Is there an easy way (or a way) that I can dynam...more >>

I can create connection managers for paradox, either ado.net odbc or plain old odbc, but what do I use them with? There seem to be no dataflow components that can use these connections. By the way, is there going to be an ssis forum someday? ...more >>

I have a dts package that creates a CSV file including today's date in the filename. Once the file is created, I plan use an Execute Process Task to call an app (ws ftp) that uploads the file to an ftp server. I want to specify this filename as a parameter in the Execute Process Task so I can...more >>

For some reason, importing text files (Tab, CSV, etc) into Access seems more stable than DTS into SQL. Many times I'll get date/time conflicts or "delimiter not found" messages DTS'ing when an import or link into Access works without a hitch. I'm dealing with large files from external system...more >>

I used the Import Wizard to Import part of a table from AdventureWorksDW sample database into my Tst Database. I define a sql query to give me the first 200 records. I parse and preview the data ok (no error there). I ask it to save the pakage and I get a prompt with encrypting sensitive dat...more >>

I executed a new package successfully 3 times. But I don't see anything in the box for 'DTS Package Log'..it's blank. Where can I find this log? Thank you Mike *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have a DTS package that executes fine on demand, but when I add it to the job scheduler it won't stop executing. I started logging the DTS job and can see through the log that the package is completing normally, but the job in the job scheduler will not stop executing until I cancel it. The j...more >>

Hi all, I've recently started the migration of a SQL 2000 database (32-bit) on Windows 2000 Server to SQL 2005 64-bit on Windows 2003 Server (64-bit). The databases migrate with no problems. However, now I'm trying to migrate our DTS packages to SSIS and I have a couple of issues. T...more >>

Hi all, I have many DTS scripts I've written over the years, and we're about to start testing MS SQL 2005 to replace our 2000 servers. Any caviets with me using my MS SQL 2000 DTS's with 2005? Can I just export to a ..dts file and import it into 2005? If I have to rewrite all this it'll ta...more >>

Hi NG, I am a newbie in DTS and want to do something "magic" with DTS: I want to import ALL files from a specific folder X into a Table T. Every file X is checked, there is always the same data in there, like "ID", "Name", "Amount". A file X has about 200 MB data. My question is: can I...more >>

I have a Source Connection pointed to a text file that we get from a 3rd party vendor. The file format is defined by them. The problem is that the file is really 3 files all merged into one with each line conforming to a fixed layout based on the type of line item it is. What I need to do i...more >>

Hi, I am trying to use a stored proc as a source for a data transformation. This sp uses temp tables. When I preview the data everything is fine. But when I try to map the transformations I get an error "Invalid object name" saying the temp table does not exist... What should I do? Tha...more >>

Hello, I have a series of .csv's that I want to DTS to a table on the server. The situation is that the column names from the csv are imported each time I execute a DTS. Is there some way to not import the headings? Thanks -- Kenny G...more >>

I have a DTS package that I copied from to another server because of lack of space. The package reads a text file and does some transformations/mapping to columns with a table. When I change the origin of the flat file I get the following message: The following tasks reference the connection t...more >>

I have a DTS package that I copied from to another server because of lack of space. The package reads a text file and does some transformations/mapping to columns with a table. When I change the origin of the flat file I get the following message: The following tasks reference the connecti...more >>

I have used DTS a fair amount in the past and have not had any problems. Recently, however, I have a situation where I have several views in a database. I have a DTS that copies the all tables, views, stored procedures to another server. I get an error message that a certain view cannot be fou...more >>

Hi all, I have a batch file that I want to run in a DTS - Execute Process Task. The tasks runs fine... for some time. Then it looses its pointer to the batch file. Then I need to open the task, and re-select the win32 process. After doing so, the task runs fine again. Even WITHOUT SAVING t...more >>

Is there a way to script this? Such as looping through a collection and save to file? We have dozens and dozens of DTS packages on a server and I see no way to back them up except to open each one manually and save to file. Please tell me that there is another way :) Thank you, -- Brad...more >>

Anyway to set a column in SSIS in proper case format (i.e, captilize the first letter in each word. Was hoping on a function within the conversion or derived data transformation tasks Change JOHN SMITH to John Smith thanks,...more >>

Is there an easy method to retrieve a identity value during/after a row is inserted in the DB-Destination Task. 1) Retrieve record with custom and address combined 2) Extract address from customer and create address record (need AddressID - Identity column) after the insert 3) Create c...more >>

I am trying to import a file where data in the Part Number Column can be formatted as 123456 and/or 70-123456. I have tried formatting the column as Text so it will import the literal string but it still ignores any numbers which don't have the "-" sign in the number ? ...more >>

Hi I have around 7 tables that get new data or updates in the production envt and I would like to insert/update these tables on a daily basis in the testing environment. Can you suggest a script to do this. Thanks Bob...more >>

I'm using the assembly Interop.DTS in VB.Net for executing DTS-packages stored local on a database-server. First I set some global variables, no issues here, but when I want to set a datasource it says that the connection cannot be found, though the name of the connection is certainly present ...more >>

I'm trying to automate uploading a file to a secure FTP site using a program called WinSCP. I can run it from the command line using something like: winscp3 /console /script=example.txt But I want to call this from the activex task. At the moment DTS tells me there is a syntax error on thi...more >>

I am importing a text file into SQL using DTS. The text file has a WBS (work breakdown structure) key that I need to do some magic on. I need to parse the WBS_KEY and generate an ID/Parent relation for every row in the table. I have no clue on what/how to do this. Text file has this str...more >>

We have a SQL scheduled job to run every 10 minutes which has been successfull always. (Win 2003 server, MSSQL 2000 with sp4) Today there was a GPF stating that the SQL job failed. When looking at the SQL job history, saw that one of the step in the job had failed with "process exit code 1...more >>

I am trying to use a datediff with a parameter in DTS as follows Select * from dbo.tbl where datediff(dd,ReportDate,?) = 1 I have set it up the global variable in Parameters. If I do preview I get "No value given for one or more required parameters" If I run it, it compeltes successfuly ...more >>

I have a data pump task to transfer records from a table to a excel. I want to automatically dump them to a second sheet, when the number of records is greater than 64k (excel limit). Is there a way by which i can dynamically create a new table in excel as well change my destination to this new ...more >>

Is it possible to write a VB installation package that will install a DTS package on a client (third party) remote site that has MSDE only. MSDE will be installed as part of the installation package. The program that we have created requires DTS to import data from DBASE into SQL, but so far I...more >>