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 |
|
smithje
Starting Member
32 Posts |
 Posted - 2009-01-27 : 12:12:41
|
| Yes I feel stupid asking this question and I'm trying really hard to keep an open mind about moving to 2005, but OMG! Why is it so complicated? I just want to edit a SSIS package created by the Import/Export Wizard and saved to SQL Server. Where is it? I've opened the Business whatever services thing and tried to browse to the package. Where is it? A search online tells me it should be in C:\Program Files\Microsoft SQL Server\90\DTS\Packages. Wrong! Where is it? Why is this so difficult? It was so simple in 2000. OK no negative thoughts here. I just need to figure this out. Where is it? Is Microsoft hiding it from me? Why would they do that? I've been so loyal to them. Where is it? Anybody? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-27 : 12:20:14
|
| just connect to integration services engine of your server through sql mgmnt studio. then expand database->storedpackages->MSDB and you should see your package. |
 |
|
|
smithje
Starting Member
32 Posts |
Posted - 2009-01-27 : 12:24:33
|
| Yes, visakh16 I can see it there but I can't open or edit it from there. How do I open it to edit? Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-27 : 12:27:43
|
| Start BIDS (Business Intelligence studio) and open a SSIS project.Click 'Project' in menu bar and select 'Add existing package' from the dropdown.In the pop-up window, type in the server name, and set the right package path. Then you will be able to work on the package directly. |
|
|
|
smithje
Starting Member
32 Posts |
Posted - 2009-01-27 : 13:07:08
|
| That did it. Thanks. Of course I didn't have a solution to open but I figured out how to create one. Just don't get why this has to be so complex and why it is not explained somewhere in the books on line.Many thanks. I will push ahead now. If this is the future I fear we have the wrong folks on the design committee. Oh well, I'm just the customer. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-27 : 13:11:53
|
| why? why couldnt you open? what was error? another way to open it is to export it as dtsx file to your local machine and then open it from BIDS. |
|
|
|
smithje
Starting Member
32 Posts |
Posted - 2009-01-27 : 13:22:28
|
| No error. Opened fine once I created a "solution". Love those "solutions" & "projects" & "builds". I guess it needed to be more complicated so the simple minded users would get out of the SQL Server pool and back in the Access pool. Thanks, I'm treading water for now. |
|
|
|
|
|
|
Where is it? SSIS saved as SQL Server