July 19, 2006 at 9:06 pm
I have legecey DTS Packages that connect to a third party Database to update daily. I can not create any new packages using obdc in SSIS. I had read one comment that said to use the Data Reader for the souce. This still does not seem to work. Any Ideas. I like 2005 but still need data from OBDC daily.
Thanks
July 21, 2006 at 6:34 am
Grant,
We ran into this same issue. Within a SSIS package, there is a SQL 2000 DTS package step. You can go in & do your ODBC "stuff" within the DTS package. What we have also done is create the DTS package on a SQL 2000 server & then migrate it over to our SQL 2005 box. Either way has worked very well for us so far.
HTH,
John
July 21, 2006 at 7:04 pm
I am just concerned about the need for it in the future. I would like to go full SQL 2005 since there are so many good features. Maybe I can keep developer copy of SQL 2000 to create the packages and then import them.
Hopefully Microsoft will put this connection back in.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply