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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 DTS 2000 Package Designer issue...

Author  Topic 

kote_alex
Posting Yak Master

112 Posts

Posted - 2008-12-15 : 02:54:22
I can't edit the package.. i have one connection linked to another... an ODBC to a OLEDB... and when i try to edit the connection string it won't let me... what's the deal ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-15 : 03:38:42
does this dts package execute by itself? also can you check if datasource is available on your server?
Go to Top of Page

kote_alex
Posting Yak Master

112 Posts

Posted - 2008-12-15 : 04:23:46
no datasourse available... I forgot to mention that ...
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-15 : 04:36:22
quote:
Originally posted by kote_alex

no datasourse available... I forgot to mention that ...


then how do you think it will execute?
Go to Top of Page

kote_alex
Posting Yak Master

112 Posts

Posted - 2008-12-15 : 04:51:37
but when I migrated the package it didn't get the datasource ... how can i get that?
Go to Top of Page

kote_alex
Posting Yak Master

112 Posts

Posted - 2008-12-16 : 02:39:19
so no help from anyone? :(
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-16 : 03:11:59
try this & see if it helps

http://windowsitpro.com/article/articleid/21491/how-do-i-migrate-odbc-data-sources-from-one-server-to-another.html
Go to Top of Page

kote_alex
Posting Yak Master

112 Posts

Posted - 2008-12-16 : 09:18:55
it helped a bit but the deal is that I need to migrate that package from a server to another and I dont have looging permisions on that server... :| because the odbc.ini is on that server... and even if I install it on my server won't that mess up my server... because I overwrite my odbc.ini with another... ?

anyone?
Go to Top of Page
   

- Advertisement -