July 23, 2008 at 4:46 am
I've created the following code, which executes an existing package. After I've run it, the table is created, however, it has no data in it.
Private Sub Form_Load()
Dim dtsApp As Application
Dim package As IDTSPackage90
Set dtsApp = New Application
Set package = dtsApp.LoadPackage("C:\Carl\Changed_CIC\Package1.dtsx", True, Nothing)
package.Execute
Set package = Nothing
End Sub
If I run the package from within BIDS, and I then check the table, it has rows in it.
I have no idea what could be causing this. I've made sure that the source file has data in it, and in both instances, both refer to the same source file.
July 23, 2008 at 5:15 am
I assume your package has a step to create the table and a data flow task to fill it.
So, the package is failing after the table is created but before the data flow.
It could be lots of things, permissions on the source data, a version problem, a problem with the Edition of the SSIS server your VB6 program is running on, etc.
I suggest you turn on package logging and examine the error messages.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply