| Author |
Topic |
|
soorajtnpki
Posting Yak Master
231 Posts |
 Posted - 2011-04-28 : 06:45:22
|
| Hi all,I have a dts task for pulling data from one db to another db. The task is like that destination tables will be drop & create and then the pump task is pumping data to the created tables. The dts is working without any error.Sometimes, some tables are seen as blank like drop&create worked but pump task is not done...at this time we are getting success messaage as "succeesfully completed"...why this is happening? how to figure out this?IS there any related bug with dts tool?Any ideas/help please...thanks in advance...... |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-04-28 : 07:31:56
|
maybe the workflow isn't set correct so sometimes the pump task comes first and then the drop/create?maybe the source has no rows so the pump task has nothing to pump it over?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-28 : 07:33:10
|
| Are you sure you are doing the drop and create before the import?Log the progress of the package.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2011-04-28 : 09:09:01
|
quote:
Originally posted by webfred
maybe the workflow isn't set correct so sometimes the pump task comes first and then the drop/create?maybe the source has no rows so the pump task has nothing to pump it over?
No, you're never too old to Yak'n'Roll if you're too young to die.
hisource has data, I have checked...Interesting thing is that if I run that dts again it will poupulate all tables as expected...so this issue happens sometimes... |
|
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2011-04-28 : 09:11:52
|
quote:
Originally posted by nigelrivett
Are you sure you are doing the drop and create before the import?Log the progress of the package.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy.
hi,Can you please tell me how to log the progress of the package...as I am a newbie to this dts stuff...thanks in advance... |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-04-28 : 09:45:16
|
What's about the workflow I was aking for?Do you have a green (or blue) arrow pointing from the drop/create task to the data pump task?If not then the order of executing the steps isn't reliable.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2011-04-28 : 09:51:39
|
You are right,In workflow, under precedences, all tables are setup there, except the issue causing one...Thanks a lot for helping out....quote:
Originally posted by webfred
What's about the workflow I was aking for?Do you have a green (or blue) arrow pointing from the drop/create task to the data pump task?If not then the order of executing the steps isn't reliable.
No, you're never too old to Yak'n'Roll if you're too young to die.
|
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-04-28 : 09:56:17
|
glad to help 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
soorajtnpki
Posting Yak Master
231 Posts |
Posted - 2011-04-28 : 10:02:22
|
quote:
Originally posted by webfred
glad to help
No, you're never too old to Yak'n'Roll if you're too young to die.
One more case I forgot to tell you...I have one more pump task which is little bit different than others in the same dts task, it is not drop&create as it is only doing delete from destination table as we need to keep some records over in that table and we need the data from source too..., this one is getting duplicates....how to figure out this onethanks in advance |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-04-28 : 10:11:43
|
Are source and destination databases on the same server?Then you can use a select statement as input for the pump task.select id, col2, col3, col4, ... from source_db..source_table as t1where not exists(select * from destination_db..destination_table as t2 where t2.id = t1.id)
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
dts sometimes working fine and not always