| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2009-12-11 : 12:13:00
|
| Hi,I had to disable and enable an step of a DTS package in SQL Server 2005 several times in order to execute the DTS and verify the notification is working. The task was a “rebuild index task” that some tables were selected to be reindexed. The other night the job failed and I discovered there is no table selection in the Rebuild index task while it was already there. I was told that my disabling/enablings has caused the step loses its content. Is this true?Thanks!Canada DBA |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-12-11 : 12:52:22
|
Please don't send mail to directly to members just to ask the same question you posted. If we have time to answer questions then we saw your post. I saw it but had no experience with this particular problem so I didn't respond.>>I was told that my disabling/enablings has caused the step loses its content. Is this true?that question seems like an easy enough thing to verify with a quick test though. What were your findings?  Be One with the OptimizerTG |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-12-11 : 14:40:32
|
| Hopefully he didn't go through the entire first page of members because there's a lot of people between you and me :)Be One with the OptimizerTG |
|
|
|
CanadaDBA
583 Posts |
Posted - 2009-12-11 : 15:51:59
|
| Well, I didn't think any of you get an alarm about the posts on "SSIS and Import/Export (2005)". That's why sent out private emails. Both of you didn't help anyway... :)Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-12-11 : 18:35:16
|
I got an email too and I am not on the first page.But I am sorry because I have no answer to that question.I am going to avoid that SSIS-stuff whenever it is possible - I don't like it very much...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
CanadaDBA
583 Posts |
Posted - 2009-12-13 : 15:28:57
|
| I sent the email to about 8 - 10 member whom their last logon on the forum was DEC 11th. I wished to get your answers in my email instead of my post because now, the number of replies to my post is not Zero anymore and therefore less people may look at it and perhaps have an "answer" to my question. :(Canada DBA |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-12-13 : 22:51:23
|
| Like webfred I'm not much of a SSIS guy. But as I mentioned in my original post, this seems like a very simple thing to verify yourself. Have you tried to set up a "rebuild index task" then do nothing by disable-enable it and see if you loose your table selection?btw, anyone respond to your direct emails? That is another problem with the email approach, current and future forum readers don't get the benefit of the responses.Be One with the OptimizerTG |
|
|
|
CanadaDBA
583 Posts |
Posted - 2010-01-07 : 13:06:42
|
| The only answer I had through email was that this could be a big bug in SQL Server if what I was told is true.BTW, I have SQL Server version 9.0.4035.Canada DBA |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-07 : 13:14:13
|
| whats your integration services version? look into visual studio or business intelligence development studio |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Can Disable/Enable a task cause task content lost?