Viewing 15 posts - 1 through 15 (of 37 total)
Simple and elegant.
This one worked for me straigt from the 'box'.
Tom
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:
Dim objPackage
Set objPackage = DTSGlobalVariables.Parent
For each objGlVar in objPackage.GlobalVariables
Set...
August 27, 2003 at 12:18 am
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...
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?
-Tom.
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.
- Tom.
July 21, 2003 at 6:37 am
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...
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
move another...
June 3, 2003 at 9:15 pm
Viewing 15 posts - 1 through 15 (of 37 total)