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 |
|
fsunolefan
Starting Member
10 Posts |
 Posted - 2010-07-15 : 11:44:03
|
| Looking at a particular job step property, i notice that you can select a 'Package'. Upon browsing, i can see a folder called SSIS packages but i cannot find that on any of our servers anywhere. Is there a way to view these packages and edit them?thanks! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-15 : 14:45:18
|
I believe they are stored in the server. Ask the people which have deployed the packages.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
fsunolefan
Starting Member
10 Posts |
Posted - 2010-07-15 : 15:10:56
|
| That person passed away 2 weeks ago, webfred. I thought there may be some explanation somewhere about how to edit an SSIS package. I can find info on how to create one and import and export one but not how to modify one.. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-15 : 15:54:07
|
"How to modify a SSIS package" isn't a short story.You have to edit it in MS Visual Studio. But for this you need it as a <packagename>.dtsx file.Log on to the server where the packages are stored (you can see this in the job step).But don't choose the sql engine. Choose server typ=integration services. There it is possible to export a package to the file system I think.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2010-07-16 : 11:51:11
|
| Yes, you have to export the package from SQL Server. The package will either be in the File System or MSDB folder. Right-click the package to export. Create a new Integration Services project in Visual Studio and then right-click on SSIS Packages. Choose Add Existing Item and browse to the exported package (<filename>.dtsx) -Cheers |
|
|
|
|
|
|
SSIS packages