Where is SQL Server 2005 ?

[George1111]

I have SQL Server Express Edition installed and working properly

I wanted DTS ( or whatever 2005 calls it) to import some MDB databases into SQL Server 2005 or Express (it doesn't really matter)

So I load up my SQL server 2005 Developer Edition ie, the full version, wait about 1 hour for it to install and at the end, I have no extra anythings on my menu - zip - nothing extra to what it was prior to installation

I am looking for Enterprise manager - doesn't exist

Told it to install Analysis Services and Reporting services - nowhere to be found except an old version of analysis servoces hang over from 2000 version

Do I need to uninstall everything before I can upgrade to get DTS working ?

[Shuja Ali]

SQL Express by default does not contain DTS or SSIS. take a look at [url=http://blogs.msdn.com/euanga/archive/2006/07/20/672272.aspxthis BLOG[/url]. You can use BCP or OPENROWSET.

[George1111]

I have installed Sql Server 2005 Full Professional Edition - Complete

There is no enterprise manager on the menu

I can't find a menu option for analysis services either

There is no reference to dts (even in the help it refers to DTS only with SQL Server 2000

There is no reference to DTS included in SQL Server 2005

QUESTION - Is there DTS included in SQL Server 2005 ?

If there is - where do I find it ?

Thanks

[George1111]

I notice that DTS is now called SSIS and is to be found in Business Intelligence Development Studio

I watched Business Intelligence Development Studio being installed and configured when installing SQL Server 2005 but, as with everything else, I cant seem to find it in the menus

Do I need to uninstall everythiing that resembels SQL Server and start from scratch ?

Ie, Delete all refereneces to SQL Server 2000, SQL Server Express, existing installations of SQL Server 2005 ?

It scares me to do this as I have many databases connected to these servers - but if this is the only way SQL Server 2005 might work properly, what other choice do I have ?

[Shuja Ali]

There is no DTS in SQL 2005. There is something new which is known as SQL Server Integration Services (http://msdn2.microsoft.com/en-us/library/ms141026.aspx). Also take a look at this http://msdn2.microsoft.com/en-us/sql/aa336312.aspx

Also there is no Enterprise Manager. What you need is the SQL Server Management Studio which is more user friendly and is free. You can download Management Studio from here (http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en)

[George1111]

Hunting around my system I have found what I believe to be DTS (or perhapos its SSIS)

It is a wizard for migrating data

I ran it on my MDB file and got these errors

Do you know what it means ?

Thanks


Validating (Error)
Messages
Error 0xc02020f6: Data Flow Task: Column "Company" cannot convert between unicode and non-unicode string data types.
(SQL Server Import and Export Wizard)

Error 0xc02020f6: Data Flow Task: Column "Branch" cannot convert between unicode and non-unicode string data types.
(SQL Server Import and Export Wizard)

Error 0xc02020f6: Data Flow Task: Column "LockPassword" cannot convert between unicode and non-unicode string data types.
(SQL Server Import and Export Wizard)

Error 0xc004706b: Data Flow Task: "component "Destination - AP_Params" (28)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

[George1111]

This is the wizard I am running - no mention of DTS so I suppose it is SSIS ?????

[Shuja Ali]

Yes this is a screen shot of Import Export Wizard provided by the Integration Services component.

Now going back to the error that you are getting. There have been some changes in the way SQL Server does Import Export. In DTS, SQL server used to do implicit conversions, but in 2005 this has been eliminated. So now you have to do Explicit conversions. You will have to add Data Conversion Transformations to the package. You should take a look at MSDN for more.

[hspc]

Column "Company" cannot convert between unicode and non-unicode string data types
Is the "Company" column in the destination table defined as varchar or nvarchar ?

[George1111]

I have changed all the definitions to have Unicode Compression and I am now getting nVarChar fields in SQLExpress. It is now working (apart from the error below)

Thank you