DTS Package From VB

[robwilliams71]

Hi,

I've created a VB package, and trying to run it from a VB project. Works fine on my PC with SQL Enterprise Manager installed, but not on another developers PC.

I've looked on t'internet, and TEK-TIPs and tried registering DLLs.

I've tried both ways in the code - creating a DTS Object

e.g. Set oPkg = CreateObject("DTS.Package")

and also executing a stored procedure which has the command to run a DTS Pckage

i.e Select @CommandLineVarChar = "DTSRun.exe /S XENA\AS_P800_0010 /E /N RMBWST_FIN_COPY_TEST /R"

But neither work, and it doesnt give an error - even stepping through the source code doesnt help.

Any suggestions please as its driving me MAD!!!

Thanks in advance
Rob

 

[AlexCuse]

Does the other PC have the same network drive mappings, and is it able to 'see' the SQL Server? If this is the case, you should probably post some more of the code you are using.

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[tb]

Permissions on the package ... who is the owner

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!