How to execute SSIS package using vb 6.0

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.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

How to execute SSIS package using vb 6.0

Author

Topic

srinivas.alwala
Starting Member

30 Posts

Posted - 2007-11-29 : 01:48:34

Hi,

I have created a SSIS package in sql server 2005.
When I execute the package directly it works properly.

The purpose of package is to create a dollar table in sql server destination and import data from sheet of an Excel file which is source.

Now I need to execute this package using vb 6.0 by creating an exe file.

If you have code regarding the same.

Kindly let me know.

Regards,

Srinivas Alwala

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-29 : 02:15:56

Tried call dtexec.exe?

srinivas.alwala
Starting Member

30 Posts

Posted - 2007-11-29 : 07:20:51

Hi,

I have used the following code to execute the package.

Made exe name as Daily.exe

An error displays as package,id.versionid does not exists.

Dim mnFileNo As Integer
Private Sub Form_Load()
Call cmdStart_Click
End Sub

Private Sub cmdStart_Click()
On Error GoTo ErrorMsg
Const DTSSQLStgFlag_UseTrustedConnection = 256
Dim pObj1 As New Dts.Package

mnFileNo = FreeFile(5000)
Open App.Path & "\DTS_Log_" & Format(Now, "ddmmyy") & Format(Now, "hhmmss") & ".Log" For Append As #mnFileNo

Print #mnFileNo, "Daily_DCR_Srini Import Started on " & Format(Now, "hh:mm:ss")
pObj1.LoadFromSQLServer ServerName:="ipAddress", ServerUserName:="pcname", ServerPassword:="pcpassword", Flags:=DTSSQLStgFlag_UseTrustedConnection, PackageName:="packagename"
MsgBox "Package Exists."
'pObj1.Execute ' Execute the Package.

kindly, let me know what changes required to execute the package.

srinivas.alwala
Starting Member

30 Posts

Posted - 2007-11-30 : 01:42:25

Hi,

I have tried dtexec.exe its working properly.

By using above exe in production server, the package executes properly but if i use the exe from some other machine to execute the package which is in production server the package does not executes.

Kindly, let me know what changes need to be taken in exe utility to execute the package which is created in production server where sql server 2005 used from development server where sql server 2000 used.

Regards,

Srinivas Alwala

srinivas.alwala
Starting Member

30 Posts

Posted - 2008-01-01 : 08:58:19

Hi,

I have been facing problem for executing ssis package using vb 6.0 since more tha a month.

If anybody have solution for it.

Kindly let me know.

Regards,

Srinivas Alwala

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources