|
|
-
Sudeep Raj Commented 3 Months ago through Blogs
How is your XML structure? Is it a simple one like I used?...
|
-
Sudeep Raj Commented 3 Months ago through Blogs
Hi Paresh,
Did you have Excel connections in your Packages? You will see this error for Excel connections generally. Another reason for this happening could be that the User running the job does not have the necessary privileges....
|
-
Sudeep Raj Commented 3 Months ago through Ask
Hi Rihan,
The links you chose will work only when the metadata of all the sheets are the same. Instead what you could do in inside the 2nd For each loop have 4 data flow tasks(DFT). One for each tab. Set them up separately. Now use a empty sequence c...
|
-
Sudeep Raj Commented 3 Months ago through Blogs
I would prefer to use SSIS Raw file to stage the data from prod, and then use these Raw files to restore the data to the other server.
Using raw file is the fasted way to have a backup of the data in case of any failure we donot want to hit the prod...
|
-
Sudeep Raj Commented 3 Months ago through Tutorials
That's simple, double click the precedence Constraint (green Arrow) change the condition from Success to Completion....
|
-
Sudeep Raj Commented 3 Months ago through Blogs
Store the value in a variable and map it in REadOnlyVariable in Script Task pop up.
In the actual script you need to use it like:
//Override the AcquireConnections Method to set up the connection once for the file.
public override void AcquireCo...
|
-
Sudeep Raj Commented 4 Months ago through Blogs
You could mail it to me sudeep@beyondrelational.com...
|
-
Sudeep Raj Commented 4 Months ago through Blogs
Could you share your XML sample here....
|
-
Sudeep Raj Commented 4 Months ago through Blogs
Hi Quillis
Are you using the same settings in this blog with the same XML?...
|
-
Sudeep Raj Commented 4 Months ago through Ask
When is the Max id used for logging?
Can you not have a package run after the load to do this logging?...
|