Issues accessing DTS packages on SQL Server 2000 from SQL Server 2008R2


 i have sql server 2014 , sql server 2008r2 installed , trying access dts packages on sql server 2000 sql server 2008r2. on window 7, 64 bit machine.

after sql server 2008r2 installed, installed,

microsoft sql server 2005 backward compatibility components-
sqlserver2005_bc_x64.msi
and
microsoft sql server 2000 dts designer components
sqlserver2005_dts.msi

then manually copied files from-
c:\program files (x86)\microsoft sql server\80\tools\binn
copy
semsfc.dll
sqlgui.dll
sqlsvc.dll
to
c:\program files (x86)\microsoft sql server\100\tools\binn\vsshell\common7\ide

c:\program files (x86)\microsoft visual studio 9.0\common7\ide

then navigate
c:\program files (x86)\microsoft sql server\80\tools\binn\resources\1033
copy
semsfc.rll
sqlgui.rll
 sqlsvc.rll
to
c:\program files (x86)\microsoft sql server\100\tools\binn\vsshell\common7\ide\resources\1033

but didn't help. can see dts packages, when right click , open error

i error-

sql server 2000 dts designer components required edit dts packages. install special web
download, "sql server 2000 dts designer components" use this
feature. (microsoft.sqlserver.dtsobjectexplorerui)

i can see components installed in control panel. please suggest do?

thanks

hi pinkruby,

there similar case error in link, , suggestion changing path environment variable.

you need add “c:\program files (x86)\microsoft sql server\80\tools\binn\; ” before ”c:\program files\microsoft sql server\100\tools\binn\;” in the path environment variable, , restart ssms.

but think changing the path environment variable affect running 2008 version package. suggest try call in batch file qualified name  instead of changing path environment variable.

regards,

seif wang



SQL Server  >  SQL Server Integration Services



Comments

Post a Comment

Popular posts from this blog

Reindexing

hi     using sql server 2005 ee sp4. our database size 150 gb. weekly once schedule reindex job. ran 4 5 hours maximum. but recent days getting more 13 hours. the possibilities there? ragu thangavel how perform reindex? maint plan? or check fragmentation first , reorganize fragmented? if later, quite more data nowadays fragmented before. if not, consider doing "smart" defrag (ola.hallengren.com). tibor karaszi, sql server mvp | web | blog SQL Server  >  SQL Server Database Engine
Read more

Users List

hello everyone, i"m builing tool tfs , want user list form tfs "assigned to" field. if 1 can post code review i"ll gled.   thanks hello, to imports users tfs, can try this: using microsoft.teamfoundation.server; using microsoft.teamfoundation.client; using microsoft.teamfoundation.workitemtracking.client; icredentialsprovider provider = new uicredentialsprovider (); teamfoundationserver tfs = teamfoundationserverfactory .getserver(“your_server_name”, provider); tfs.authenticate(); igroupsecurityservice gss = ( igroupsecurityservice )tfs.getservice( typeof ( igroupsecurityservice )); identity idsid = gss.readidentity( searchfactor .accountname, "team foundation valid users" , querymembership .expanded); identity [] idusername = gss.readidentities( searchfactor .sid, idsid.members, querymembership .none); foreach ( identity id in idusername) {       if (id != null && id.type == identitytype .windowsuser) ...
Read more

List of charts

Image
i'm trying build report show activity for reservations placed and satisfied month branch. the report has parameter the item category and dataset has fields month category branch reservations placed reservations satisfied on front sheet i've created system wide figures 2 columns per month and a matrix broken down category (e.g. child fiction, child non fiction, adult fiction, adult non fiction) has row , column totals. i want have page each branch in system. what's best way of approaching this?  add parent group based on branch field in row groups  and add page breaks repeat matrix report every branch. please mark answer if post solved problem. milan das SQL Server  >  SQL Server Reporting Services, Power View ...
Read more