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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 ssis working with existing package

Author  Topic 

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2014-02-11 : 17:36:17
I have an SSIS package that I would like to open and see what it contains. I have never used an SSIS editor to look at what is in an SSIS package. (I have worked with DTS packages years ago).

Thus I have the following questions about looking at and possibly modify an SSIS package that is setup for a swql server 2008 or sql server 2008 R2 database:
1. What type of file should I open? Should I open a file called ssispackage.sln? Is the last node called *.sln?
If not, what type of file should I open?
2. Is there a certain type of visual studio editor that I should use? For example, for an SSRS reports I open a bids editor and for programming in C# I open up an editor that is setuyp for C# programming.
3. Basically can you give me directions on how to open and work with ssis packages that are for sql server 2008 or sql server 2008 r2?
   

- Advertisement -