[dba-SQLServer] SSIS, SQL Server Integration Services, DTS

Hi Arthur

OK, I'll have a closer look.
Perhaps I should just clean it up and install the SQL Server 2005 Standard.

/gustav

>>> fuller.artful at gmail.com 18-01-2008 19:21:24 >>>
There is a very subtle little checkbox in the installer, and it defaults to
True, which means that you want to install the Express Edition. Why MS
decided to default it to True, I don't know, but it causes myriad downstream
problems. You have been bitten by said "feature".

As to the saved pkg, that depends upon where you decided to save it (file
system or inside the DB).

A.

On 1/18/08, Gustav Brock <Gustav at cactus.dk> wrote:
>
> Hi Arthur and Robert
>
> Just realised what the SQL Server Configuration Manager is for ...
> It showed that I have two SQL 2005 Servers installed locally, SQLEXPRESS
> and MSSQLSERVER. Of these, the first is the Express edition I guess (from a
> previous install of Visual Studio 2005 Express) and the second must be the
> developer version installed with VS2005 Standard.
>
> The second wasn't running. I started it and somewhere I noticed a tip to
> create a DTS package: Run DTSWizard from Start Menu, Run.
> That wizard connected happily to a server and offered to save and run the
> created SSIS package ... OK, and yes it did. Success!
>
> Now I need to find out how to get to that saved package ...
>
> /gustav