December 4, 2011 at 11:16 pm
H All,
We have one Master packge.In master package we have used for each Loop container for loop repetition purpose. I have applied Check points for Master package, But check points is not working and Package is fail in For each Loop container .is it Working checkpoints for Each loop container other Wise any suggestions (For each loop Container it should required in My Package).
Regards
MSBI
December 5, 2011 at 2:11 am
What is the error that you get?
Wise suggestion: do not use checkpoints. They only bring pain and misery 🙂
Design your package in a way that you can restart it without giving data corruption/inconsistency.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 3:10 am
Iam getting these Error: The type of the value being assigned to variable "User::CustomerID" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
Regards
MSBI
December 5, 2011 at 3:35 am
Hmmm, at first sight that error has not much to do with checkpoints.
How do you populate the CustomerID variable?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 4:00 am
We have entered in Manually Customer list ,Actual thing is we have 10 customers, my master package is loading one by one Custmoer.Master package is fail it's again point of failure onwards that is doing check points. But package is Fail again rerun direct for each loop container fail.
Let me tell one thing my approach is Correct or Not? Any alternate suggestions, please Tell him
Regards
MSBI
December 5, 2011 at 6:56 pm
Have you setup the each Control Flow Components property correctly. You need to setup them in order to see the chekcpoints working corrrectly. Here is an example.
SSIS: Checkpoints implementation
http://www.singhvikash.in/2011/10/ssis-checkpoints-implementation.html
Vikash Kumar Singh || www.singhvikash.in
December 5, 2011 at 9:22 pm
Hi,
I am Given Correctly That type options. After that Exact For each loop container is fail! Please give him any Suggestions
Regards
MSBI
December 6, 2011 at 12:02 am
I'll ask the question again: how do you populate the CustomerID variable?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 6, 2011 at 2:14 am
Hi Koen,
I have created one variable for Customer List and manually entered the Values in Customer List (i.e. 1, 2, 3, 4, 5)
Regards
MSBI
December 6, 2011 at 4:49 am
So if I'm guessing it correctly, you have a For Each Item loop?
Which columns did you define and what are their datatypes?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 6, 2011 at 10:39 pm
Hi Koen,
Yes! We have for each loop container. I am selecting for each loop ADO enumerator, Enumerator configuration is I am selecting USER::Source Queries (Data type is Object) variable Enumerator Mode is Rows in the first table option is selected and Variable mapping is USER::Customer ID. This is my for each loop configuration....
Regards
MSBI
December 7, 2011 at 12:00 am
We're getting somewhere. The variable @user:source queries, how is it populated? How many columns does the resultset have and what are their datatypes?
What is the datatype of the @CustomerID variable?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 7, 2011 at 12:38 am
Hi,
User: Source queries (Data type is Object) variable is we have created manually and Total package Source Queries is stored in that variable. @CustmeorID data type is Int32
Regards
MSBI
December 7, 2011 at 1:51 am
msbi2049 53516 (12/7/2011)
Hi,User: Source queries (Data type is Object) variable is we have created manually and Total package Source Queries is stored in that variable. @CustmeorID data type is Int32
Regards
MSBI
How did you create that variable manually?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 9, 2011 at 6:42 am
Not sure about the entire issue but Checkpoints do not store the runtime values of OBJECT data type variables. You might be facing this issue becoz of this.
____________________________________
Vikash Kumar Singh || www.singhvikash.in
Vikash Kumar Singh || www.singhvikash.in
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply