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 |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2008-04-22 : 18:23:08
|
| Folks:After migrating our SQL 2000 DTS packages to SSIS I wanted to know what changes I will have to make to my VB code. Here is the VB code I use to execute 2000 DTS package. Anybody with VB or similar situation.... what changes I will have to make so that I can execute my SSIS (sql 2005) package.Dim BalancesPackage As New DTS.Package BalancesPackage.LoadFromSQLServer("SERVER NAME", "", "", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, "", "", "", "DTS PACKAGE NAME")BalancesPackage.Execute() |
|
|
bigey3
Starting Member
6 Posts |
Posted - 2008-04-23 : 09:05:47
|
| hi, i have the same problem like you,but my vb code dont work properly to execute my DTS on sql server 2000.i use loadfrormsqlserver fonction like you.please can you provide to me a part of your vb code??thanks a lot.see you |
 |
|
|
|
|
|
DTS to SSIS and VB Code