Viewing 15 posts - 1 through 15 (of 37 total)
Simple and elegant.
This one worked for me straigt from the 'box'.
October 4, 2005 at 7:17 pm
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...
June 6, 2004 at 4:27 pm
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...
June 3, 2004 at 10:48 pm
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...
May 24, 2004 at 8:23 am
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...
May 23, 2004 at 6:08 pm
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...
May 17, 2004 at 8:09 pm
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...
May 16, 2004 at 5:28 pm
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.
January 28, 2004 at 4:01 pm
You need to reference to parmeter in your lookup as ? that is without apostroph '
January 28, 2004 at 3:51 pm
You cannot save the values of the global variables from run to run.
As for looping through global variables:
Set objPackage = DTSGlobalVariables.Parent
For each objGlVar in objPackage.GlobalVariables
August 27, 2003 at 12:18 am
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?
July 23, 2003 at 7:55 am
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?
July 22, 2003 at 6:30 pm
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.
July 21, 2003 at 6:37 am
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...
July 21, 2003 at 5:57 am
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
June 3, 2003 at 9:15 pm