Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
roykauf
Starting Member
36 Posts |
 Posted - 2008-06-16 : 05:51:01
|
| Hi everyone. I'm trying to make a new DTS on SQL 2000. I have a bug that i haven't seen before. After making the connection - from OLE object to File (destination object) with a query i'm unable to see the populated list which generally made by 'Execute' button. i pressed the 'execute button , but nothing had happend. as a result of this, DTS is not complete. Does someone knows about this bug?? can I solve it? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-16 : 06:06:54
|
| Are you able to preview data from OLE object in preview tab? |
 |
|
|
roykauf
Starting Member
36 Posts |
Posted - 2008-06-16 : 06:09:29
|
| Yes. sure, everything works except this. I don't know what's the problem |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-16 : 06:10:25
|
| Does DTS execution become successful? if not, waht is the error thrown? |
|
|
|
roykauf
Starting Member
36 Posts |
Posted - 2008-06-16 : 06:12:36
|
| No ' it's not succeful , cause I must finish this step - SQL must know how to connect between columns (fields) and this step is critical, it cannot be skipped |
|
|
|
roykauf
Starting Member
36 Posts |
Posted - 2008-06-16 : 06:13:25
|
| it doesn't throw any error. also in event viewer |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-16 : 06:15:45
|
quote:
Originally posted by roykauf
it doesn't throw any error. also in event viewer
So you're telling that the execution progress went to completion without any error in any of tasks or is nt it that execution progress window didnt appear at all? |
|
|
|
roykauf
Starting Member
36 Posts |
Posted - 2008-06-16 : 06:30:58
|
| no..can i please sent you an email with print screens ? |
|
|
|
roykauf
Starting Member
36 Posts |
Posted - 2008-06-16 : 06:33:16
|
| can you please write me your email and i will send you print screens. i don't know how to send it here |
|
|
|
|
|
|
a Problrm with DTS in SQL 2000