up vote 0 down vote favorite
share [g+] share [fb]

im a newbie with sql-server 2005. i build some packages which import some flatfiles into tables, each file goes into his table. Now there is a change in the structure of one file.

Now i am too stupid to change this package which is stored on the server in msdb. Please be kind and explain the steps to get the package in visual studio for editing, thx.

link|improve this question
100% accept rate
feedback

2 Answers

up vote 1 down vote accepted

I'm assuming you're talking about an Integration Services package, as these are the only "packages" that get deployed to the MSDB database :)

To edit a package that's been deployed to MSDB, you'll need to connect to the Integration Services instance on the server, locate the package, and export it as a .dtsx package.

Then you should be able to open it in Visual Studio, edit it, and redeploy if necessary.

link|improve this answer
Sounds like the way i did it some months ago. i'm not familiar with that sql-2005 thing, but isn't it possible to manage them like sql-2000? At my point of view it's an overkill to do something like exporte as *.dtsx an reimport it - is that the truth? I'm very confused. – Ice Dec 16 '09 at 20:10
SQL 2000 used something called DTS (Data Transformation Services) to do what Integration Services does. Integration Services allows you to edit the source of the files (allowing e.g. source-code control), run the files directly without deploying, deploy to multiple servers, etc., all of which DTS made quite hard. The cost, of course, is that you have to use Visual Studio to edit the packages, where in SQL 2000 it was all done in Enterprise Manager :) – Jeremy Smyth Dec 17 '09 at 16:58
You are right, but me as a database passionate everything in the filesystem is evil... – Ice Dec 17 '09 at 22:40
feedback
up vote 0 down vote

By package, I assume you mean table or similar.

The easiest thing you can do for SQL 2005 is download SQL Management Studio Express for free and then login,and you can delete, modify or do anything with any databases currently loaded in your SQL instance.

link|improve this answer
Sorry, it's my fault; i mentioned no table. As i'm not so familiar with that ssis-thing... – Ice Dec 16 '09 at 20:14
sorry, my fault, I missed the term package! still, download Management Studio Express - as per your comment on Jeremy's answer, Management Studio Express is probably what you are looking for. – William Hilsum Dec 16 '09 at 20:36
Management Studio Express has no features that allow modification of SSIS packages. Sorry, your answer has no relevance to his problem :) – Jeremy Smyth Dec 19 '09 at 11:03
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.