Viewing 15 posts - 1 through 15 (of 15 total)
Actually, I dont have any input in a way to be presented, Its just I want an approach to do this problem.
I can put it in steps like this:
> OLE...
July 15, 2010 at 6:19 am
I have used AppDev videos to learn SSIS.
You can either buy them or search for the video links in rapidshare.
I found the SSIS 2005 videos from AppDev better than the...
June 23, 2010 at 2:27 pm
Robert Biddle (6/23/2010)
1. Execute SQL Task ("Get ETL Info"): Returns Result Set with SourceTableName and DestinationTableName mapped to a resultset variable.
I think in the 1st step, we should use Data...
June 23, 2010 at 1:59 pm
I tried a work around for this:
1) In the For Each Loop Variable Mappings map Index 0 to a string variable (user::filepathname)
Set Folder Path
Set Files: *.zip
2) With in the For...
June 22, 2010 at 3:16 pm
imani_technology (6/20/2010)
I have a configuration table on another database (not msdb). Would that cause a problem?
I can answer this...
Configuration table can be any where, any data base. Connection to...
June 22, 2010 at 9:50 am
June 21, 2010 at 2:44 pm
TRY THIS:
ISNULL([var_a] == [var_b]) ? (ISNULL([var_a]) && ISNULL([var_b])) : [var_a] == [var_b]
LET ME KNOW IF IT WORKS
THNX
June 21, 2010 at 2:07 pm
The best way to use Execute SQL task is to have the SQL statement as an expression.
Whatever parameters you want to pass should be declared as user variables.
In the execute...
June 18, 2010 at 12:10 pm
Parameters can be passed to the where clause if the entire query is stored in a string variable.
If there are 2 parameters to be passed, then create 3 variables.
One variable...
June 17, 2010 at 12:46 pm
Keep the child package out of 1st transaction...
Child package should be called using the Precedence Constraint = Success..
December 18, 2009 at 8:06 am
Try putting the tasks in a sequence container.
Sequence containers are meant to handle transactions
December 17, 2009 at 1:51 pm
Yes you are right
I was missing the AND in my join...
working fine now.
Thanks
December 9, 2009 at 4:54 pm
Viewing 15 posts - 1 through 15 (of 15 total)