SQLAuthority News – Migrating DTS Packages to Integration Services

Migrating DTS Packages to Integration Services
Writer: Brian Knight
Published: July 2008

SQL Server Integration Services (SSIS) brings a revolutionary concept of enterprise-class ETL to the masses. The engine is robust enough to handle hundreds of millions of rows with ease, but is simple enough to let both developers and DBAs engineer an ETL process. In this whitepaper, you will see the benefits of migrating your SQL Server 2000 Data Transformation Services (DTS) packages to Integration Services by using two proven methods. You will also see how you can run and manage your current DTS packages inside of the SQL Server 2005 and 2008 management tools.

Ready white paper Migrating DTS Packages to Integration Services

Abstract &  courtesy : Microsoft

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

6 thoughts on “SQLAuthority News – Migrating DTS Packages to Integration Services

  1. Sorry For asking a Dumb Question!
    I am a absolutely new learner to SQL.
    I have two tables say, A and B in a data base x.
    A and B has got ID which we can treat as Primary key.
    In table A I have fields called InitialAmount and Final Amount.
    In table B I have field called Consumed.
    The FINAL field in A is InitialAmount-FinalAmount
    I used PHPmyAdmin and queried on Table A:
    UPDATE A,B
    SET A.Final=(A.InitialAmount-B.FinalAmount)
    where A.ID=B.ID

    I want whenever the user edits consumed I want A.Final to get substracted.

    I know it might be very basic query. I am worried since the querry is succeeding but Final is not updating.

  2. Hi Hari,
    I would run this sql on the database for a specific ID and see if the final amount is updating just to troubleshoot this issue.
    1. Either there are no matching ID’s on A and B.
    2. Just make sure B.finalamount is populated.
    3. Make sure there are NO NULL values in these columns InitialAmount and FinalAmount, NULL’s can throw off the math.
    4. Try using ISNULL(A.InitialAmount,0)- ISNULL(B.FinalAmount,0).

    These would be someof things I would try.

    Thank you

  3. Help Me out!!!

    I have 40 columns in a table and at times I have to update two or three columns and the thing is Column names are dynamic in nature depends on the need the End Users will update the column. I want to write stored procedure in such a way that any number of column the user wants to update he can without affecting out columns of the table.?????????????? This is the query and any one hep me out………..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s