Launch a package from VBA...

Hi all,

I'm trying to launch a SIS package from a VBA macro in excel...now I launch the dtexec.exe from a shell but a have this error:

Started: 10.14.33
Could not load package "Package1" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
Source:
Started: 10.14.33
Finished: 10.14.49
Elapsed: 16.594 seconds

but all credential are correct...

any ideas ?

thanks in advance

Wolly

Hi, Wolly.

1) Please post the *exact* command-line you typed.

2) Did you use the /U and /P flags to specify the credentials?

-Rieekan

|||

Wolly,

Please ignore my previous post--here is a probable solution:

1) From the command line, you can invoke the "DTExecUI" utility. It helps you build a command line by specifying options in the GUI.

2) When you have specified the package you want to run, simply click the "Command Line" item (at the bottom), copy the contents of the "Command line" textbox, then paste the newly generated command line into your VBA shell command.

Hope this helps!

-Rieekan

sql