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 |
|
Zoma
Yak Posting Veteran
76 Posts |
 Posted - 2008-05-08 : 05:01:09
|
| HI All,Ive been having problems with my Reporting services! Now I want to change my DTS Package settings & connections,which were modified on the other server from Our Client,I want them to execute running on my server.There are serveral connections made to this DTS Package,The DataSources Im having troubles with,were using OLE DB Conn.in other I was able to use my server I changed it to use ODBC Driver for SQL. This packages also have Microsft JET Database Engine and The error I get "It could not found Installable ISAM"I use SQL 2005,One of my Collegues told me to Install SQL2000/Found ISAM Driver.Now im just a Junior DBA,With no experience &Its just my 1st time working with SQL& Im dont know what they Talking About.Please Help me Out If You Can |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-08 : 05:09:28
|
quote:
Originally posted by Zoma
HI All,Ive been having problems with my Reporting services! Now I want to change my DTS Package settings & connections,which were modified on the other server from Our Client,I want them to execute running on my server.There are serveral connections made to this DTS Package,The DataSources Im having troubles with,were using OLE DB Conn.in other I was able to use my server I changed it to use ODBC Driver for SQL. This packages also have Microsft JET Database Engine and The error I get "It could not found Installable ISAM"I use SQL 2005,One of my Collegues told me to Install SQL2000/Found ISAM Driver.Now im just a Junior DBA,With no experience &Its just my 1st time working with SQL& Im dont know what they Talking About.Please Help me Out If You Can
Are both the Servers 2000? Also is this for a one time running? If not i think you can define configuration variables to take the values of connnection properties automatically based on server where package is running.http://www.databasejournal.com/features/mssql/article.php/3073161 |
 |
|
|
|
|
|
|
|
DTS PACKAGE