0

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.

2 Answers 2

3

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.

3
  • 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, 2009 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 :) Dec 17, 2009 at 16:58
  • You are right, but me as a database passionate everything in the filesystem is evil...
    – Ice
    Dec 17, 2009 at 22:40
0

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.

3
  • Sorry, it's my fault; i mentioned no table. As i'm not so familiar with that ssis-thing...
    – Ice
    Dec 16, 2009 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. Dec 16, 2009 at 20:36
  • Management Studio Express has no features that allow modification of SSIS packages. Sorry, your answer has no relevance to his problem :) Dec 19, 2009 at 11:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .