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 |
|
shimon
Starting Member
1 Post |
 Posted - 2007-01-29 : 16:02:12
|
| Hi AllI am trying to export a View to xls but unseccessfuly. "Destination Connection OLE DB is not Exist. ??? in SQL 2000 it was easy i export it save it as DTS Package , Schedule it and i had a Job. I face many difficalties trying to do the same thing now. your help will be blassesShimon Fadida |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-29 : 18:05:18
|
| You can either create and edit a new package in the Business Intelligence Development Studio (BIDS), which gives you a much improved package designer. Or you can do everything in SQL Server Management Studio (SSMS) with the Export Data wizard. If you want to edit the package that is created by the wizard you'll need to use BIDS.In SSMS - Right click the database and select Export Data.The Export Wizard will take you through all the steps to create and save a new SSIS package. To execute the package again later, click Connect above the Object Explorer window and select Integration Services (this is important - you will not find your package in the regular Database Engine connection where you are used to looking for DTS). Now expand Stored Packages and you'll be able to navigate to your package. Note - you cannot edit the package here, just execute it and manage it (see history and so on) - you must use BIDS to edit packages. |
 |
|
|
|
|
|
Export View to Xls