0
1
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.
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 – 2009-12-16T20:10:59.260
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 – 2009-12-17T16:58:09.553
You are right, but me as a database passionate everything in the filesystem is evil... – Ice – 2009-12-17T22:40:36.523