The package don´t run the data flows in a vb.net program
-
When I run a package in Microsoft Business Intelligence Studio the package run Ok but if I run the same package compilated in a vb.net program the package don´t execute the data flows. Can you help me...?
It´s very important for me...
the code in vb program is:
Dim app As New Application
Dim PaquetePrueba As New Package
Dim vars As Variables
Dim strSqlRutaPaquetesTraspaso As String = "C:\Documents and Settings\rramon\Mis documentos\Visual Studio 2005\Projects\ImportacionDatosPreventa\ImportacionDatosPreventa\bin\"
PaquetePrueba = app.LoadPackage(strSqlRutaPaquetesTraspaso & "Package3.dtsx", Nothing)
Dim result As DTSExecResult = PaquetePrueba.Execute(Nothing, Nothing, eventListener, Nothing, Nothing)
the result is failure but no error...
Can you tell me some possible solutions?
Thanks a lot
-
The machine EXECUTING your application must be an SSIS server. Where the package is stored, having the SQL client tools installed, etc. does not mean anything. To test this, just double-click on the dtsx file and execute it from the dialog that appears. If you get no dialog, or the package complains about not having the appropriate version or edition of SQL, you are not running an SSIS server with the correct edition for the package you have created.
-
Thanks for your answer...
I have installed visual studio 2005 sp1
I have Sql Server Business intelligence Development studio
The packages are in my computer but attach other server where sql-server is.
When I do Double-click in a package an Execution Package Utility appears.
Can you help me...It´s very important for me. I spends some days.
-
So you double-click the dtsx file and the dialog appears, but can you run it successfully from the dialog?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply