January 7, 2014 at 2:05 am
how to implement conditional split in control flow ssis to set the Package configuration
January 7, 2014 at 2:29 am
There is no conditional split in the control flow.
Also, your question is not clear at all. What do you want to achieve?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 7, 2014 at 3:29 am
Look up precedence constraints and expressions.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
January 7, 2014 at 3:40 am
Logged Operations :
Create a .config file concept for enable log or not..
If log is enabled then :
After Successfully Execution of Package just write a log into Notepad, Table and do a provision to Send this file on a particular mails with following fields :
fields are in the log file : Status of Execution (Success / Failed),Database Name (With Source & Destination),Execution Date, Table Name (Source & Destination), No. Of Rows Transfer, Previous Count of Rows, After Importing No. of Count of rows in each tables
--we have to develop for the existing package.
January 7, 2014 at 3:45 am
You cannot use the standard logging for this (I don't think you can switch it on/off using configurations and it doesn't have all the info you need).
You can however store all the logging information in variables. Using an expression on a precedence constraint (and the expression uses a variable set by the configuration), you can determine if the values of those variables should be written to a file or not.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 7, 2014 at 3:51 am
Can you please briefly explain how to implement by using precedence constraint.
January 7, 2014 at 4:06 am
Using Constraints and Expressions
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply