Hi all, I have this problem where I have to frequently change the target database of my transform data tasks. I've already figured out how to change the destination tablename through ActiveX script, but I don't know how I can drop all existing transformations and recreate them (since they re...more >>

How can I use dts to transfer data back and forth between a text file on a Unisys mainframe and a table in SQL server? How do I set it up? I checked out the bulk insert reference, but if I went that route, what would be the syntax? Paramter references such as "from datafile" doesn't tell me...more >>

Can DTS outperform pure T-SQL on inserts when the source and destination are in the same database? I have a staging table with the same schema as my destination table. My destination has 200 million records and my staging table has 30 million records. Do you have any suggestions on indexi...more >>

SQL Server 2005 - SSIS OK. We know there is Header rows to skip options and it works great. I've got the file that has a "footer". Here is an example: .. PSC filename=table1 records=0000000000525 ldbname=db1 timestamp=2006/02/07-16:25:00 numformat=44,46 dateformat=mdy-1910 map=NO-MA...more >>

Hi, i´ve create a SSIS package and run it on Visual Studio to see if everything ok, and it run´s. When i try to run on SQL 2005 Integration Services i get an error "... transfer sql server objects task cannot run on this edition..." Any idea? Thanks, Rui Reis ...more >>

Hi All, I've just transfered all the DTS packages i have on an old SQL 2000 server to a new SQL 2000 box, and they appear to have lost all the structure and notes that had been placed in them. Is this correct, and is there a way to prevent it occuring, as these notes form a valuable part...more >>

Hello Is it possible to execute a DTS package from a Trigger. If so, can I also pass a parameter to the package from within the Trigger. Many thanks David...more >>

Hi folks... I'm bringing in Data from a Terradata Warehouse to a SQL server table it's a table with 4 cols cols two of which are dates. I worked out that the following dates were breaking SQL server validation 0001-01-01 0004-04-01 etc... clearly these are not dates... so I did this in...more >>

Is it possible to install SQL Server 2005 Integration Services on a server that does not run SQL Server 2005? In other words, does the "SQL Server Integration Services" Windows service require the presence of the "SQL Server" Windows service? Is it possible to run .dtsx packages without th...more >>

I have two simple DTS packages in version 2000 that are about as simple as they come. One extracts from a table and dumps into an Excel file, the other takes the Excel file and appends it into the table from which it came. These took all of about two minutes to create usine DTS in SQL Server 2...more >>

Hello everybody, I am new to this concept of DTS and SSIS and I havent worked on databases before. I have been trying to migrate frm MYsql to MSSQL 2005 using this SSIS importn export wizard , but I realised it doesnt recognize the Mysql.as one of the data sources. Pls help. How do I d...more >>

Actually, I want to parse a pipe delimited text file into SQL database and also check(validate) the values in some of the data fields (eg. state field Not more than 2 chars..etc). Is the DTS package useful for this? I learnt from a few forums that DTS package would be the most efficient way to...more >>

Hello, Does Integration Services (2005) support surrogate keys? Thank you!...more >>

Hello, I want to put data from an Access-database into a SQL-server2005 database, using SSIS Data Flow. The problem I've got is that I cannot convert a string value (like '20060101' for the first of januari 2006) from the Access database into a Datetime value in the SQL-database. I try to use...more >>

Greetings, I am a newbie in using DTS. I would like to load data from 1 single excel sheet[tab] into multiple fields of different tables in database. EXAMPLE: DATABASE TABLE Table 1: COURSE course_code course_name faculty_code(FK) ...more >>

Hi there, I'm been trying to to find how to list all available DTS packages on SQL Server, but still got no result. Can anyone please guide me. I'm having hard time try to understand the Class Library. Thanks in advanced. Yanto ...more >>

We have a database where one table contains the file-data for documents. The table contains: filename of datatype nvarchar(2000) filedata of datatype image(16) What I want to do is to export the files to regular files. So a file in SQL2000 becomes a file in the filesystem with the name of ...more >>

Dear experts, I'm an Oracle guy, looking to pick up SQL Server. I've installed SQL Server 2000 on XP (home). I'm now trying to navigate SQL Server. In Oracle, I would just open SQLPLUS, and query away. SqlPlus looks like a DOS window, or telnet window into Unix. It just has the dot pro...more >>

Using 2005, SSIS... OK - I'm trying to loop through all the *.txt files in a certain directory, and using each filename, call an executable, passing the filename as an argument to the executable. I started by adding a foreach loop container, and made sure it was foreach file enumerator type....more >>

Hi Guys, i am a newbie at this stuff and i have a quick question. I would like to perform a BULK insert into a table. The table contains a couple of varchars columns, two Guid columns and datetime column. One of the Guid columns is automatically added newid(), but the other one is a...more >>

Hi: I am trying to create a loop based on http://www.sqldts.com/?246 , as I have done before. My loop is getting to the "Loop Around" task, but just finishing there and not going to the ActiveX Task at the beginning of the loop. I'm tearing my hair out here, it is pretty basic and I am not ...more >>

Hello again! Have a field coming in from an AS400 that's "empty" (if i highlight it in kinda looks like there might be a space there, but no letter,etc.). When it copies over to a varchar field in my staging table it doesn't come over as null, but it apparently isn't coming over as a space ei...more >>

My HR department has an application that reads data from a SQL 2000 server and displays it in ASP. In the job description field that they have to complete, there are three different areas that need to be highlighted-Job Responsibilities, Knowledge/Experience and Skills/Abilities. They input the ...more >>

Hi, In SSIS, under the workflow pane, each tasks can have precedence condition that will tell if the task will be executed or not. That's really a great feature to control the task flow. I would like to have this functionality in the DataFlow itself but data flow it does not have any pre...more >>

I'm just learning how to use DTS now and it looks like it might solve the issue I'm currently dealing with. What I want to do is set up SQL Server 2k to export data from a specific database and specific table and dump it into an excel spreadsheet - and have it automated to do it daily at xx...more >>

Hi all, One of my DTS failed due to timeout. I want to know how to change the timeout. Please give me the code and step how to change it cause I'm not a DBA or System Admin. Thank ...more >>

I need to solve a problem with sql server 7. We have a procedure that perform a database export in a local db called dbage and another procedure that move the files to a network hard disk. The "move" doesn't work. this is the sp: =============================================== CREATE PROC...more >>

Hello all, I was wondering how similar DTS is to SSIS. I don't know if we will be upgrading to 2005 any time soon, but it would be nice to know ahead of time if I will have to learn a whole new system. I'm still pretty green at DTS, but learning some new things here and there. Will all ...more >>

Hello all, I created a *.DTS file the other day that I had several DTS packages stored in. In creating new packages, I realized that the first package was obsolete and would never be used. It doesn't appear that an individual package can be deleted from a DTS file storing multiple packa...more >>

I was looking for a way to collect dts run information (errors, progress, etc). I found this article http://support.microsoft.com/default.aspx?scid=kb;en-us;321525 I did exactly as it suggested, and I receive an error at the following point: cpContainer.FindConnectionPoint(guid, cpPoint) Th...more >>

background: Informatical will allow you to set up connections once, then multiple jobs use them. Great for development, because you can change from dev to prod server in one place for as many jobs as you want. How can we achieve this in SSIS? Currently we have 3 projects with shared data ...more >>

When editing DTS 2000 packages in SQL 2005, I've also noticed that: 1. When deleting any task in the designer, you CAN NOT simply right click the task, and delete, you must highlight the task and delete with the keyboard's delete button. 2. ActiveX script tasks are not displayed with the c...more >>

Is anyone else out there having problems with SQL 2005 opening/editing/saving SQL 2000 DTS packages...even with the Backward compatibility/2000 DTS Components installed? Specifically, after installing these two downloads, I can Open a DTS 2000 package, but when opened, the icons/graphics are ...more >>

Hello all, A couple of months ago, I posted a question about having the DTS package prompting you to select the file that needs importing. Someone replied with the Open File Dialog Custom Task from SQLDTS.com. I'd like to thank the person who suggested this custom task and I'd like to th...more >>

I am very new to SSIS and have no prior experience with DTS. I am trying to read a flat file and conditionally split it out into 2 different flat files based on a certain column. Unfortunately, there are certain rows in the source flat file that have low values in the middle of the row. When S...more >>

All, I'm new to SSIS and really need you guys’ help. Here is my problem. I need to copy data from number of tables to the staging tables in a DB, These are just direct copy and doesn’t need any changes during the extraction. The process basically copy each of source table to their sta...more >>

Hi I'm exporting data using SSIS from a stored procedure call to an EXCEL destination. I can set the Excel column names to the names of the fields returned via the stored procedure. I however need to set these column names to something different. Ideally I don't want to change the parama...more >>

Hi All, Since I've installed SQL Server SP4, when I want to create an ActiveX Script on a WorkFlow properties of a Task, MMC Crashes !! (Memory could'nt be written) Does anyone have the same problem and maybe a solution ... Thanks a lot for any help. AB ...more >>

Hi , I created 3 task to transfer data on a package. When I manually run the package by clicking on the "run" icon on the DTS package desgin interface , all the task are failed and the error msg = "Not Run". But when I manually trace the individual task to right click on the transfer...more >>

I am trying to get an ActiveX script task to fail. Using the script below it always goes to the on-success leg. Can someone tell me how to fail this task so it goes to the on-failure leg/. '********************************************************************** ' Visual Basic ActiveX S...more >>

I did set up an SQL Agent Proxy account, logged it on the server (in a Remote Desktop), and created various Outlook Profile to be used from within DTS Packages. They all are copies of one initial profile to cover the various profile names found on clients ("Outlook", "MS Exchange Settings", ......more >>

A basic question I know, but can somebody tell me how to add On Success, On Failure and On Completion arrows between tasks? I have done quite a bit of DTS, but never had to use these before. Thanks, Mike *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi experts Could I ask some advice on migrating an MS Access mdb file to SQL Server. The access database has about 50 table with relationships and I was hoping to use either DTS or SSIS to do the bulk of the work. I use the access database as a model/template for the larger system which ...more >>

Hi all, I am building a DTS package which picks up a flat file. Once the last sql t5ask has been completed successfully I would like to move the file to another folder. I would also like to timestamp the file in order keep an archive. Many thanks Mike...more >>

Hi all: I am trying to catch DTS error in window application C#, but i can't . please help me out. Cheers Nick ...more >>