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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-07 : 08:25:49
|
| Rolf writes "Hi,I've a simple question. I've started SQL enterprise manager, and made a connection with an SQL server. I click on 'Data Transformation services', then 'Local Packages', then i choose a package and rightclick on 'Design package'. I click on the flow (workflow, green arrow ) between two icons, and rightclick on 'Properties'. Then i click on 'Transformations' trying to see the Visual Basic code that is behind it. But instead i get the error message:"Error source: Microsoft JET database EngineError description: 'L:\blabla.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to server on which the file resides."Thanks for any help.Rolf." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-07 : 08:52:24
|
| Is there an L:\ drive on your server?If so, does blabla.xls exist there?If not then find the correct path on your Excel connection.. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-07 : 08:57:40
|
| Also make sure that file exists in Server and not in the client you are usingMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Package error: error source: microsoft JET database engine