When I tried out a  SSIS FuzzyLookup task, I experienced a problem as below:
- Task:            SSIS FuzzyLookup
- source:         SQL 2005 table
- reference:     another SQL 2005 table

I am a newbie. I am trying to configure Dynamic Properties task in a DTS
package. The DTS package is supposed to move data in 6 tables from one of the
Production servers to the Test Server. The Production Servers can either be
PROD1 or PROD2 that will be passed to the package ...

If I change the target database to a different SQL Server database
(with exact same table names and structure), it doesn't change the
database and I have to manually change all my transformations to point
to the new database. Is there an easy way to change all the

I have a table which has an update trigger to keep the log's table.  I need to do a bunk update and don't need to track the logs.
How can I stop the trigger before running my SQL Task (DTS) and re-start the trigger when the task is completed
From http://www.developmentnow ...

Good day,
when I execute a simple DTS package from DTS Designer in Visual
Studio, it takes 5 Seconds to execute. The same package lasts about 50
seconds when I start it via DTExec in a stored procedure. I can see in

I have a DTS that's dependant on 3 other DTS's completing
successfully. How can I set this up so it will run only after those 3
have executed successfully?

I am using MS SQL Server 2000 Standard Edition with SP3a.  I have created a
package to FTP some files from our Mainframe to a local directory on the same
SQL Server box.  I have scheduled the package to execute at a specific time
everyday using the job scheduler in MS SQL Server. ...

We have a DTS package that runs twice a day. this package gathers data from an AS400, FoxPro for DOS, and 2 other sql server instances and the data is used for reporting purposes through Crystal Reports.
If a report is requested with invalid parameters, a Lock Mode of IS (Shared ...

I output 20+ columns to a raw file in one data flow step and read in 5
columns from that file in another (later) data flow step.  My task is
to add a 6th column that already exists in the file (and in the
previous RFS definition).  My problem is the Advanced Editor for RFS

I'm trying to write a vbscript that checks to see if a file exist
before kicking-off a DTS import and I wanted to know the following:
How can I have the script return a Successful or Failure execution?
This will help me determine whether the rest of the DTS continue or

If I'm importing from a .CSV file into a table and it gets interrupted
or fails to complete the import for any reason, is it possible to
rollback any changes that occured so the table goes back to its
original state? Thanks!

have a dts which has 2 path's that come to the same "Sql Task".
i dont know why but when i remove one of the arrow's with event
like success/completion everything works great!
but when i have 2 "event" that come to this "SQL TASK" they sql like skip it

Im trying to set up an ASP that will trigger a DTS package.  Have seen
the example on sqldts.com:
 http://www.sqldts.com/207.aspx
And I can get his working OK.  How would one alter this code to

Hello, I need to export data from one database to another.  One of the tables
in the destination has an extra column which is a identity column.  How can i
inset an incrementing value into this column.  This column does NOT exist on
the source side.

I have an SSIS package that emails a spreadsheet exception report.
Naturally, I only want to send it, if there are exceptions.
What can I use to query for the exception and only allow the workflow if
Count(exception) > 0