Viewing 8 posts - 1 through 8 (of 8 total)
I would add "WHERE ....... and '['+b.name+']'<>'[PK_'+a.name+']'" because my server likes to be lazy.
September 29, 2014 at 3:42 am
Nice Example to find out that Date can have Time included
January 30, 2014 at 3:57 pm
In my Parent/Child configuration i had trouble with "each child package and i selected the connectionmanager property's connection string" and changed it to "link the StringParentVariable to the StringChildVariable then...
November 13, 2013 at 8:02 am
Okay, my first attempting is right.
In the Parentpackage you have the Variable ConnectionString.
Make the same Variable in each ChildPackage
Then in the CildPackages, instead to point to XML, choose ParentPackageVariabel, link...
November 13, 2013 at 7:16 am
I think i missunderstood you, sorry.
You will change the connection path from childtask.
In the properties from ExecutionTask there is "Expression" where you can change the Connection with Expression builder (or...
November 13, 2013 at 6:41 am
Google or Bing or... is your friend.
try with "ssis parentvariable", that finds more about this theme then you ever can read
try the first one: http://www.bidn.com/blogs/mikedavis/ssis/155/passing-variable-values-from-parent-package-to-child-ssis
November 13, 2013 at 6:26 am
Something like
select
NullValues =
case when col1 is null then 1 else 0 end
+case when col2 is null then 1 else 0 end
+case when col3 is...
November 13, 2013 at 6:19 am
Use ParentVariable
November 13, 2013 at 6:08 am
Viewing 8 posts - 1 through 8 (of 8 total)