Have you turned Logging in your package ON, and log to a local text file? Provide the entire path in the textbox and read the results after completion?  This will usually help find...

One thing to keep in mind while using a Lookup, you can cache your lookups... now, of course this is only going to offer performance gains if you are actually...

Remi,  I've written a simple .Net utility that will allow for a connection to 2 different SQL Servers and compare most recent versions of DTS Packages and allow you to...

A few things to check... Does your table, [invoiceheader], really only have a single column in it and maybe an ID column?  Do all of your other columns, if any...

Not sure if this is what you are looking for, but I have used the following stored proc create a job to execute a DTS Package on demand from a...

Your problem is that your CSV file is saved using a Text Qualifier.  You are missing a closing double quote in a column that contains a comma in the column...

I've used this for the same problem:

If ISDate( DTSSource("COL009") ) Then

     DTSDestination("COL009") = CDate( DTSSource("COL009") )

Else

     'Set your Default Date Here... or remove the entire...

Not sure if this will help, but can you instanciate and use the WshShell.Run method and use the last param to run the process syncronously?  I think this would get...

It appears that your global variable is not initialized when you are building your commandtext string.  My guess is that it is currently defined as Nothing.

DTSGlobalVariables("RefreshEndDate").Value = Now()

I believe should be...

Have you looked at the ADODB.RecordSet methods GetRows() and GetString()?

I think this functionality is what you need.  The only question is how do you want to structure your receiving array...

-Mike...

If you are performing several queries.. most times where you are just viewing the data in a table or a subset of the data, you can avoid locking of the...

If you are running the Package as a Job, usually it is the SQL Server Agent account.  If you are in Interactive mode, it will access the FSO via the...

Check to see if objPkg is defined as a Package object rather than a Package2 object.  Load the package with the following method call.

objPkg.LoadFromSQLServer "WMCCWKTBSWZ90EZ", "asp", "rob", 0, Nothing, Nothing,...

While you are dropping the FK Constraints, you my want to check if you also have indexes on the tables that you are about to import into.  After the import...

I used the ,"? OUTPUT" in several packages successfully.  Then others it did not work at all.  I have not researched it enough yet to determine when and why it...