Simple and elegant.

This one worked for me straigt from the 'box'.

Tom

If you cannot setup parameter - you can use ActiveXScript in the worklflow tab

in which you will dynamically change your query without passing parameter.

I'll give you an example where...

I would import this to one table with just one field long enough to accomodate all type of records you may have - then I would use

the DataDrivenQuery Task...

May be you have no access to that column - so when you select *

then you cannot as you do not have access to that particular column. Check if...

When creating the connection for the destination make sure you check the box for first row has column names.

When using datapump task - for the first time at the destination...

How did you blank out the property?

I use an activeX script task before calling the ExecutePackageTask to blank this property as below ( and it works for me for 3...

I have founf DTSFTPTask not reliabale. It can only pull file not push.

I have created the wrap around the http://FTP.EXE program from Windows System folder. to get...

As your select statement has only one column you cannot rereference it inside the script as MYuser_id(0) as it is not an array. Use MYuser_id instead.

You need to reference to parmeter in your lookup as ? that is without apostroph '

You cannot save the values of the global variables from run to run.

As for looping through global variables:

Dim objPackage

Set objPackage = DTSGlobalVariables.Parent

For each objGlVar in objPackage.GlobalVariables

Set...

Hi Michael,

Just to be sure - are you opening the package and then execute your task and then checking value of the global variable - all in one session?

or...

How do you run the package (task) and when do you test the content of the glVariable?

Are you doing it all within DTS designer?

-Tom.

Why not in your DataPumpTask or DataDrivenQuery Task use the lookup to update the source record to reset your "exported" field in the OnInsertSucessPhase of the transformation.

- Tom.

Hi,

Sorry for the length of the post - but I found it necessary to include part of actual code.

I was thinking about writing an article based on my code...

The good thing about my procedure is that I can save it as a package.

I can repeat the process (after modifying it if necessary) to:

copy to another server

move another...