Hi everyone, I have seen many articles and posts related to migration of Stored Procedures into SSIS Pacakges. However, I am looking for migration of SSIS Packages into SQL Stored Procedures in SQL Server 2000. Can somebody suggest me the best articles asap? Thanks in Advance Bangaaram

I have seen many articles and posts related to migration of Stored Procedures into SSIS Pacakges. However, I am looking for migration of SSIS Packages into SQL Stored Procedures in SQL Server 2000. Hello Bangaaram, I guess you are asking about downgrading SSIS (SQL Server 2008/2005) packages to DTS packages (SQL Server 2000 format). No stored procedures are relevant then, right? Then the answer is you have to do that manually. I mean you need to re-implement the same functionality in SQL Server 2000 DTS. Arthur My Blog

I have seen many articles and posts related to migration of Stored Procedures into SSIS Pacakges. However, I am looking for migration of SSIS Packages into SQL Stored Procedures in SQL Server 2000. Hello Bangaaram, I guess you are asking about downgrading SSIS (SQL Server 2008/2005) packages to DTS packages (SQL Server 2000 format). No stored procedures are relevant then, right? Then the answer is you have to do that manually. I mean you need to re-implement the same functionality in SQL Server 2000 DTS. Arthur My Blog Hi ArthurZ Thanks for the reply but, my question is How to convert DTS(2000) Packages into Stored Procedures in SQL Server 2000. I just have SQL Server 2000 installed on my machine. Thanks Bangaaram

Well, manually, again, and it depends on what is inside a DTS package. You will need to attack that on a package by package basis. Please note this forum discusses SSIS packages, I know the DTS one is no longer available, but it seems you will mostly need help with T-SQL implementing functionality say as bulk loading files, so again, this forum is not the best place for your questions regarding the T-SQL.Arthur My Blog

I am a new member here and thought this will be the right forum to ask my question. Anyways thanks for the quick response. I will ask these questions in the respective forum. Once again, thanks a lot. Regards Bangaaram