DTS Precedence Error
-
Hi
I am pumping a texfile into sql and clean up the same using Stored Procedure by Execute SQL Task. , then i try to pull Processed data from the SQL to a File. In this package i am unable to Set the Workflow after Execute SQL-Task.
It gives me Selected Precedence is not valid.
Kindly suggest me how to proceed.
Thanks for all.
Cheers,
Raja
Rajaraman.S
Analyst Consultant for
Datawarehouse & Datamart -
Make sure your package steps are like this
Text File (Source)
DataPump
Database (Destination)
On Success
ExecuteSQl
On Success
Database (Source)
DataPump
Text File (Destination)
When you create the OnSuccess workflow after the ExecuteSQL task make sure you select the second database connection.
You can do it with only one database connection, but it's much clearer with two.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
-
Hi Phil,
Thanks, I figured it out on the other day itself, but i used the same connection.
where in Melbourne? I am also in Melbourne.
Kindly Keep in touch, my id is swaraj22@indiatimes.com
Cheers,
Raja
Rajaraman.S
Analyst Consultant for
Datawarehouse & Datamart
Rajaraman.S
Analyst Consultant for
Datawarehouse & Datamart
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply