Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Chinwa
Starting Member
20 Posts |
 Posted - 2006-12-18 : 16:00:17
|
| Hello all,I have been searching the web and I am having some difficulity.We have set up a SQL Server 2005 test server. I am trying to get my old DTS packages that were written created in SQL Server 2000 to still run.The old was was in VB.net 2002 I added a library reference for DTS and then basically have in a subroutine:Dim oPkg As New DTS.Package2()oPkg.LoadFromSQLServer("SQL-SERVER", , , DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, , , , "EI Flat File Creation")oPkg.Execute()oPkg.UnInitialize()oPkg = Nothingwhich worked just fine. I see with SQL Server 2005 this will no longer work.I have read about a DTS runtime library that needs to be imported but I can not seem to find it in the vb references to add and I have installed the 2005 management studio. It is Microsoft.SqlServer.Dts.Runtime Anyone out there know what I am talking about?I know that I will need to upgrade/migrate the DTS 2000 packages to SSIS format but I am unfamilar with SSIS.Anyone know how to do that? Not migrate the DTS packages, but run a SSIS package from VB.Net? So what I am looking for some help on is:1) figure out how to get my old DTS packages created in Sql Server 2002 to run in VB.net 2002 and SQL Server 2005 - import the Microsoft.SqlServer.Dts.Runtime library and find some example code.2) figure out how to convert the old DTS packages(which there is a migration tool for) into SSIS format and then figure out how to make that run in a VB.net 2002 applicationAnyone? Thank-youPS: I realize this is a SQL and a VB.Net problem but was hoping some of you SQL gurus might be familar with this intergration issue. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-12-19 : 09:31:26
|
| You can upgrade the dts packages to ssis.All it does is embed the dts package in an ssis package but it might get round the problem you are having.Why didn't you use dtsrun to execute the packages?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Chinwa
Starting Member
20 Posts |
Posted - 2006-12-19 : 10:08:19
|
| I am not familar with DTSRUN.Is that for executing an old DTS package from VB.NET in the SQL 2005 environment?The little information I can find on doing that is:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=292891&SiteID=1and that points me to a runtime library that I can not seem to find a reference to in VB.NET.The spot I am in is that even if I migrate them to SSIS format/package, I still do not know how to execute them in vb.net application running on a clients machine.There seems to be much internet threads on "yes you will need to migrate" or "SSIS is better" but all high level and no real details on how to run them.I think that with my limited experience with 2005 (2 days worth) I am not googling the right question/phrase. |
|
|
|
|
|
|
DTS in 2005