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)
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.
@Hari,
Try UPDATE A FROM A,B ….
UPDATE t1
SET t1.Final=(t1.InitialAmount-t2.FinalAmount)
FROM A as t1 inner join B as t2
ON A.ID=B.ID
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
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………..
Can you give some more informations with examples?
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