Make sure activate Execute on Main Package Thread (workflow properties) and put this line at the end of the script: Main = DTSTaskExecResult_Success

JFB

Check this out

http://www.databasejournal.com/features/mssql/article.php/2196461

JFB

I'm not an expert, however, did you try to put an extra quote in you where statement?

strSQL2 = "select * from table1 where id in (select id from table2 where...

1.You can't use mapp drivers in dts pkgs.

2.Use UNC path like \\serverName\folder\subfolder\

JFB

1. sa is a special account for sql server. It should be a reason why??, I dont know because I never use sa.

2. You need to delete guest user from...

Follow this steps and let me know if it works?

1.Create a new user in sql server 2000 (dtsUser) and password

2.Set this user for msdb database

3.Create a sample DTS package and...

Here is an example in how to use dts on .net

http://www.sqldev.net/dts/DotNETCookBook.htm

Regards

JFB

Hi, create a userDTS in you msdb database and give permissions to this user to run the package.

Regards

JFB

Hi, to perform this, you need to go to the Transform Data Task Properties (black line) --> tranformations --> Edit.

JFB

Hi,

You should create a dts user in you sql server box and set permissions for this user to run a dts pkg.

Regards

JFB

Hi,

You can replace the name using workflow properties for the destination source file step with this example code.

Regards

JFB

'********************************************

' Visual Basic ActiveX Script

'********************************************

Option Explicit

Function Main()

Dim oConn, sFilename

Set oConn = DTSGlobalVariables.Parent

'...

Hi,

Is this you problem?

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q188/2/89.asp&NoWebContent=1

JFB

Hi,

You can perform a loop DTS package, here is an example to get the idea.

http://www.swynk.com/friends/green/dtsdirloopstep.asp

JFB

What are you doing inside the pkg?

Are you using cubes?

Make sure the account running sql agent have permissions in the places where DTS is working.

JFB

Hi,

Here is something to start with

http://www.sqldts.com/default.aspx?6,107,277,7,1

Good way is to import all into a temp table and then update you main table, also it's better to have one connection...