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 (https://blog.sqlauthority.com)

Business Intelligence, Data Warehousing, SQL White Papers
Previous Post
SQLAuthority News – Migrating to SQL Server from Other Database Products
Next Post
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2

Related Posts

7 Comments. Leave new

  • 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.

    Reply
  • 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

    Reply
  • 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………..

    Reply
  • Dear Pinal sir…

    I have a requirement in my company

    I have 2 databases(like A and B where A is old database and B is new database) with different schemas. My task is to mapping the old database with my new database…

    shall i go for using “Data Compare for SQL Server” (DBForge) ?? can this tool compare the databases that have different schemas ???

    Or can i use DTS Package for this task.. ? ?

    please clearify me this doubt Pinal

    Reply

Leave a Reply