October 1, 2008 at 2:33 am
HI ALL
* IN SSIS PACKAGE TABLE TO BE DOWNLOADED WILL BE SOURCED THRU VARIABLE.
* WHEN I AM ASSING VALUE TO VARIABLE USING EXECUTE SQL TASK ITS THROWING IN ERROR WHEN THE TABLE NAME IS NOT THERE OR THE VALUE WHICH IS ASSIGNED
TO THE VARIABLE IS NULL
* THE IDEA IS, WHILE DOWNLOADING DATA WHEN THE PACKAGE FAILS. IT SHOULD NOT START FROM STARTING (SAME TABLE SHOULD NOT DOWNLOAD FOR THE DAY TWICE WHEN WE RE-RUN THE JOB ANY TIME)
* SO FOR ALREADY DOWNLOADED DATA THE VARIABLE WILL BE ASSIGNED OR NULL ( THE SELECT STATEMENT WHICH RETURNS THE TABLE WILL NOT RETRUN ANY RECORD)
* IN ABOVE MENTIONED SENARIO I AM GETTING ERROR IN THAT PACKAGE. AND I AM USING SEQUENCE PACKAGE SO IT FAIL AND TOP AT FIRST LEVEL ITSELF
SO SUGGEST ME HOW TO OVERVCOME THIS CRYSIS
RAJASEKARAN T
October 1, 2008 at 9:42 am
Why not have some conditional flow in your control flow? If the table has been created dont make it do the data flow, else make it do the data flow.
October 3, 2008 at 1:12 am
Hi
First Thanks for the reply.
I tried the idea but the conditional task can be placed only inside the data flow task and the error is occuring before reaching the data flow task.
The design is First A execute sql task will assign value to variable ( which is table name) Once that step is success full then only it will move to data flow task. step 1 itself it.
Rajasekaran T.
October 5, 2008 at 9:56 pm
Disable validation
October 6, 2008 at 11:45 am
You can double click on the connector after your Execute SQL task and change the "Evaluation operation" value to Expression from Constraint and then add an expression like @[User:: ]!= NULL. this will stop the process from advancing if there is a null. You can also add another connector to have it go down a different path for nulls if needed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply