Migrate MSExcel worksheet sources to SQL2005

Hi,

Is there anyway I could do to migrate my data on my excel workbook to SQL Server 2005 per worksheet? Meaning, I have to create table for all my excel worksheet then transfer all the data to a new table through SSIS package.

How will I possibly do this? Please help.

Thanks in advance.

Have you tried the import wizard? That can import from Excel Data Sources.

-Jamie

|||Hi,

I just want to elaborate what I am about to do here to clarify things up.

In my case, I have 50 worksheet in my Excel workbook and I would like these worksheets be transferred in our SQL Server 2005 database, one table per worksheet. Now, I am planning to use SSIS "Foreach" control block so that SSIS recusively gets data on every worksheet, then SSIS package will transfer the data gathered on one table to another.

Is this task possible in SSIS? If not, kindly advise me of a more suitable solution for this. Or, is there any available custom script/coding for this in VS2005?

Please help. Thanks in advance.
|||

As Jamie said the Import Wizard should be able to help you.

In the SQL Server Management Studio right click on your destination database and choose Tasks->Import Data. Select Excel as your source and go from there.

Thanks.

Migrate Login Control to SQL

Hi,

I was able to create an MSSQL database with the ASPNETDB.MDF file. But how do I get the Login Control to point to the MSSQL rather than the \App_Data\ASPNETDB.MDF file?

Hi

you need to see This

Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005

|||

check out below solved thread..

Login control And DB - ASP.NET Forums

you might need to include the tables and stored procedure which requires for login control into your DB...

hope it helps./.

migrate database incl. user and password to other server

hi all,
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
im talking about sql server 2000 sp3
thanks
mic
Hi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> im talking about sql server 2000 sp3
> thanks
> mic
>
|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>

migrate database incl. user and password to other server

hi all,
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
i´m talking about sql server 2000 sp3
thanks
micHi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> i´m talking about sql server 2000 sp3
> thanks
> mic
>|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>> hi all,
>> i need to migrate a database including the user and their passwords to
>> another server.
>> create the users manually is not possible because i do not know the
>> passwords. is there a possibility to get them to another db server?
>> i´m talking about sql server 2000 sp3
>> thanks
>> mic
>

migrate database incl. user and password to other server

hi all,
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
im talking about sql server 2000 sp3
thanks
micHi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> im talking about sql server 2000 sp3
> thanks
> mic
>|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>

Microsoft.ReportingServices.Designer

Hello all,

After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.

But it exists!!!What can I do?

Many thx!

I've to inform that it looks like this file is already on my machine, and with the same version.

I tried to uninstall all SQL Server instances, NET framework 2.0 and all Vstudio (even 2003 version), restarted my machine and reinstall everything. The order was:

Vstudio for web developers Express

SQLExpress2005 Advanced

SQLExpress 2005 SP1

The installation was fine but the BIDS is causing me problems.

Sugestions?

|||

Finally solved by myself!

The order which I've done it is....

Uninstall all VStudio + SQLServer
Install .NET Framework 2.0
Install SQL Server 2005 Advanced in the default path (C:\)
Install SQL Server 2005 SP1 in the default path (C:\)
Install VStudio 2005 WebDeveloper in the default path (C:\)

Hope this helps to someone

|||

Hi:

Well, I guess the problem is the path of installation...

As most of us seems to be running out of space on 'C' Drive;

we tend to change the default path of installation...

During installation, if one sets all path to be the same drive; then the problem should disappear...

HTH,

|||

hi, i have encountered this same error message. I'm using VS 2005 Professional, it is a mature installation with several plugins and additional components, everything is customised the way i want it.

I cannot accept that i must uninstall VS2005 just to get the BI Dev Studio plugin working. That would represent a total failure of the VS integration in my opinion. all my SQL 2005 components are installed on C: so that solution wouldn't be relevant for me.

is there a response from MS on why this error message happens? and a proper way to resolve it?

hoping for an informative response :)
tim.

|||

hmmm. I have the same issue as you. I cannot uninstall my SQL server as it has production data running on it. I DID go through the painful process of uninstalling the VS 2005 installation and reinstalling it. It did not change a single thing. I am right back to the same error message.

Hope someone figures this out soon. Nothing on MS sites so far that I can find.

Brian King

|||

I had the same problem. I did my install on D: drive, but surprisingly it seems Reporting Services was installed on C: drive.

I solved the problem by copying the content of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory on the D: drive. Seems to work fine.

|||I've had the same problem and re-installed VS2005 from scratch, tried to repair .NET 2.0 but all in vain. Confirm that the above copy solution worked for me. Thanks for info Guy.|||the copying worked for me aswell, thanks guy|||

Microsoft documents it's solution here http://support.microsoft.com/?id=823245 but it didn't work for me. After repairing I found the copy
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE and it worked a treat!

Thanks!!

Microsoft.ReportingServices.Designer

Hello all,

After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.

But it exists!!!What can I do?

Many thx!

I've to inform that it looks like this file is already on my machine, and with the same version.

I tried to uninstall all SQL Server instances, NET framework 2.0 and all Vstudio (even 2003 version), restarted my machine and reinstall everything. The order was:

Vstudio for web developers Express

SQLExpress2005 Advanced

SQLExpress 2005 SP1

The installation was fine but the BIDS is causing me problems.

Sugestions?

|||

Finally solved by myself!

The order which I've done it is....

Uninstall all VStudio + SQLServer
Install .NET Framework 2.0
Install SQL Server 2005 Advanced in the default path (C:\)
Install SQL Server 2005 SP1 in the default path (C:\)
Install VStudio 2005 WebDeveloper in the default path (C:\)

Hope this helps to someone

|||

Hi:

Well, I guess the problem is the path of installation...

As most of us seems to be running out of space on 'C' Drive;

we tend to change the default path of installation...

During installation, if one sets all path to be the same drive; then the problem should disappear...

HTH,

|||

hi, i have encountered this same error message. I'm using VS 2005 Professional, it is a mature installation with several plugins and additional components, everything is customised the way i want it.

I cannot accept that i must uninstall VS2005 just to get the BI Dev Studio plugin working. That would represent a total failure of the VS integration in my opinion. all my SQL 2005 components are installed on C: so that solution wouldn't be relevant for me.

is there a response from MS on why this error message happens? and a proper way to resolve it?

hoping for an informative response :)
tim.

|||

hmmm. I have the same issue as you. I cannot uninstall my SQL server as it has production data running on it. I DID go through the painful process of uninstalling the VS 2005 installation and reinstalling it. It did not change a single thing. I am right back to the same error message.

Hope someone figures this out soon. Nothing on MS sites so far that I can find.

Brian King

|||

I had the same problem. I did my install on D: drive, but surprisingly it seems Reporting Services was installed on C: drive.

I solved the problem by copying the content of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory on the D: drive. Seems to work fine.

|||I've had the same problem and re-installed VS2005 from scratch, tried to repair .NET 2.0 but all in vain. Confirm that the above copy solution worked for me. Thanks for info Guy.

|||the copying worked for me aswell, thanks guy
|||

Microsoft documents it's solution here http://support.microsoft.com/?id=823245 but it didn't work for me. After repairing I found the copy
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE and it worked a treat!

Thanks!!

Microsoft.ReportingServices.Designer

Hello all,

After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.

But it exists!!!What can I do?

Many thx!

I've to inform that it looks like this file is already on my machine, and with the same version.

I tried to uninstall all SQL Server instances, NET framework 2.0 and all Vstudio (even 2003 version), restarted my machine and reinstall everything. The order was:

Vstudio for web developers Express

SQLExpress2005 Advanced

SQLExpress 2005 SP1

The installation was fine but the BIDS is causing me problems.

Sugestions?

|||

Finally solved by myself!

The order which I've done it is....

Uninstall all VStudio + SQLServer
Install .NET Framework 2.0
Install SQL Server 2005 Advanced in the default path (C:\)
Install SQL Server 2005 SP1 in the default path (C:\)
Install VStudio 2005 WebDeveloper in the default path (C:\)

Hope this helps to someone

|||

Hi:

Well, I guess the problem is the path of installation...

As most of us seems to be running out of space on 'C' Drive;

we tend to change the default path of installation...

During installation, if one sets all path to be the same drive; then the problem should disappear...

HTH,

|||

hi, i have encountered this same error message. I'm using VS 2005 Professional, it is a mature installation with several plugins and additional components, everything is customised the way i want it.

I cannot accept that i must uninstall VS2005 just to get the BI Dev Studio plugin working. That would represent a total failure of the VS integration in my opinion. all my SQL 2005 components are installed on C: so that solution wouldn't be relevant for me.

is there a response from MS on why this error message happens? and a proper way to resolve it?

hoping for an informative response :)
tim.

|||

hmmm. I have the same issue as you. I cannot uninstall my SQL server as it has production data running on it. I DID go through the painful process of uninstalling the VS 2005 installation and reinstalling it. It did not change a single thing. I am right back to the same error message.

Hope someone figures this out soon. Nothing on MS sites so far that I can find.

Brian King

|||

I had the same problem. I did my install on D: drive, but surprisingly it seems Reporting Services was installed on C: drive.

I solved the problem by copying the content of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory on the D: drive. Seems to work fine.

|||I've had the same problem and re-installed VS2005 from scratch, tried to repair .NET 2.0 but all in vain. Confirm that the above copy solution worked for me. Thanks for info Guy.|||the copying worked for me aswell, thanks guy|||

Microsoft documents it's solution here http://support.microsoft.com/?id=823245 but it didn't work for me. After repairing I found the copy
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE and it worked a treat!

Thanks!!

Microsoft.ReportingServices.Designer

Hello all,

After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.

But it exists!!!What can I do?

Many thx!

I've to inform that it looks like this file is already on my machine, and with the same version.

I tried to uninstall all SQL Server instances, NET framework 2.0 and all Vstudio (even 2003 version), restarted my machine and reinstall everything. The order was:

Vstudio for web developers Express

SQLExpress2005 Advanced

SQLExpress 2005 SP1

The installation was fine but the BIDS is causing me problems.

Sugestions?

|||

Finally solved by myself!

The order which I've done it is....

Uninstall all VStudio + SQLServer
Install .NET Framework 2.0
Install SQL Server 2005 Advanced in the default path (C:\)
Install SQL Server 2005 SP1 in the default path (C:\)
Install VStudio 2005 WebDeveloper in the default path (C:\)

Hope this helps to someone

|||

Hi:

Well, I guess the problem is the path of installation...

As most of us seems to be running out of space on 'C' Drive;

we tend to change the default path of installation...

During installation, if one sets all path to be the same drive; then the problem should disappear...

HTH,

|||

hi, i have encountered this same error message. I'm using VS 2005 Professional, it is a mature installation with several plugins and additional components, everything is customised the way i want it.

I cannot accept that i must uninstall VS2005 just to get the BI Dev Studio plugin working. That would represent a total failure of the VS integration in my opinion. all my SQL 2005 components are installed on C: so that solution wouldn't be relevant for me.

is there a response from MS on why this error message happens? and a proper way to resolve it?

hoping for an informative response :)
tim.

|||

hmmm. I have the same issue as you. I cannot uninstall my SQL server as it has production data running on it. I DID go through the painful process of uninstalling the VS 2005 installation and reinstalling it. It did not change a single thing. I am right back to the same error message.

Hope someone figures this out soon. Nothing on MS sites so far that I can find.

Brian King

|||

I had the same problem. I did my install on D: drive, but surprisingly it seems Reporting Services was installed on C: drive.

I solved the problem by copying the content of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory on the D: drive. Seems to work fine.

|||I've had the same problem and re-installed VS2005 from scratch, tried to repair .NET 2.0 but all in vain. Confirm that the above copy solution worked for me. Thanks for info Guy.

|||the copying worked for me aswell, thanks guy
|||

Microsoft documents it's solution here http://support.microsoft.com/?id=823245 but it didn't work for me. After repairing I found the copy
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE and it worked a treat!

Thanks!!

Microsoft.ReportingServices.Designer

Hello all,

After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.

But it exists!!!What can I do?

Many thx!

I've to inform that it looks like this file is already on my machine, and with the same version.

I tried to uninstall all SQL Server instances, NET framework 2.0 and all Vstudio (even 2003 version), restarted my machine and reinstall everything. The order was:

Vstudio for web developers Express

SQLExpress2005 Advanced

SQLExpress 2005 SP1

The installation was fine but the BIDS is causing me problems.

Sugestions?

|||

Finally solved by myself!

The order which I've done it is....

Uninstall all VStudio + SQLServer
Install .NET Framework 2.0
Install SQL Server 2005 Advanced in the default path (C:\)
Install SQL Server 2005 SP1 in the default path (C:\)
Install VStudio 2005 WebDeveloper in the default path (C:\)

Hope this helps to someone

|||

Hi:

Well, I guess the problem is the path of installation...

As most of us seems to be running out of space on 'C' Drive;

we tend to change the default path of installation...

During installation, if one sets all path to be the same drive; then the problem should disappear...

HTH,

|||

hi, i have encountered this same error message. I'm using VS 2005 Professional, it is a mature installation with several plugins and additional components, everything is customised the way i want it.

I cannot accept that i must uninstall VS2005 just to get the BI Dev Studio plugin working. That would represent a total failure of the VS integration in my opinion. all my SQL 2005 components are installed on C: so that solution wouldn't be relevant for me.

is there a response from MS on why this error message happens? and a proper way to resolve it?

hoping for an informative response :)
tim.

|||

hmmm. I have the same issue as you. I cannot uninstall my SQL server as it has production data running on it. I DID go through the painful process of uninstalling the VS 2005 installation and reinstalling it. It did not change a single thing. I am right back to the same error message.

Hope someone figures this out soon. Nothing on MS sites so far that I can find.

Brian King

|||

I had the same problem. I did my install on D: drive, but surprisingly it seems Reporting Services was installed on C: drive.

I solved the problem by copying the content of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory on the D: drive. Seems to work fine.

|||I've had the same problem and re-installed VS2005 from scratch, tried to repair .NET 2.0 but all in vain. Confirm that the above copy solution worked for me. Thanks for info Guy.|||the copying worked for me aswell, thanks guy|||

Microsoft documents it's solution here http://support.microsoft.com/?id=823245 but it didn't work for me. After repairing I found the copy
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE and it worked a treat!

Thanks!!

Microsoft SQL-DMO error 7405 on linked server query

I am attempting to execute a query on a linked oracle server. The link
is fine and I can execute the query
from query analyser but when I create the stored procedure I get this
error:
Microsoft SQL-DMO (ODBC SQL State:42000)
Error 7405: Hetergenous queries require the ANSI NULLS and ANSI
WARNINGS
options
to be set for the connection. This ensures consistent query semantics.
Enable
these options and then reissue your query.
I have looked through numerous posting on the subject and still
cannot resolve the issue.
here is the code
CREATE PROCEDURE [DBO].[TEST1] AS
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO
select sid from ......
GO
After this I attempted to alter the procdure still with no effect and
finally I issued the sp_configure 'user options',
'32' do set the default and still no luck does anyone have any other
suggestions.Try removing the GO after setting the ANSI NULLS and WARNINGS.|||ehwood@.msn.com (Eric Wood) wrote in message news:<43c03fab.0402191320.27124b8e@.posting.g
oogle.com>...
> I am attempting to execute a query on a linked oracle server. The link
> is fine and I can execute the query
> from query analyser but when I create the stored procedure I get this
> error:
> Microsoft SQL-DMO (ODBC SQL State:42000)
> Error 7405: Hetergenous queries require the ANSI NULLS and ANSI
> WARNINGS
> options
> to be set for the connection. This ensures consistent query semantics.
> Enable
> these options and then reissue your query.
>
> I have looked through numerous posting on the subject and still
> cannot resolve the issue.
> here is the code
> CREATE PROCEDURE [DBO].[TEST1] AS
> SET ANSI_NULLS ON
> SET ANSI_WARNINGS ON
> GO
> select sid from ......
> GO
> After this I attempted to alter the procdure still with no effect and
> finally I issued the sp_configure 'user options',
> '32' do set the default and still no luck does anyone have any other
> suggestions.
Well problem solved and lesson learned. The error I was receiving was
due to a bug in enterprize manager knowledge base 296769, create the
stored procedure using query analyiser and all is well.
Eric

Microsoft SQL Server Report Designer

Hi, I have installed SQL Server 2000 and Reporting Services 2005 and Visual Studio 2003 all works OK but I need to create a report with the Microsoft SQL Server Report Designer 2005 and it doesn't appear in my VS, someone could help me with this?

Marcos.

Look in [All Programs][Microsoft SQL Server 2005] on the start menu and see if you have SQL Server Business Intelligence Development Studio. If it is not there, go through the following steps Dan Jones supplied in this other thread:

You should make sure that Visual Studio is still installed. If you didn't previously have VS installed, the BI Dev Studio installation will install a VS shell called Visual Studio Premier Partner Edition. Look in Add or Remove Programs for an entry like this. If you don't find any entry for Visual Studio go to the location for SQL Server setup and run .\Tools\Setup\vs_setup.exe. This will install the VS Shell. After this is installed repair the BI Studio installation by running the following from the command line from the .\Tools directory: start /wait setup.exe /qb REINSTALL=SQL_WarehouseDevWorkbench REINSTALLMODE=OMUS

Good luck! Let us know how it turns out.

Larry Smithmier

|||

I install the VS Premier PArtener Ed. but my VS not shows the option to create a new BI project, look the link below.

http://i203.photobucket.com/albums/aa119/mcssnt/My_Screen.jpg

Marcos

|||

You need to install the SQL Server client components to get the Report Project to appear in VS.NET. Alternatively, you can use the Business Intelligence Development Studio which is included in the SQL Server client components.

|||

Thanks, when I try to install the SQL clien components the setup shows: 'An installation package for the product Microsoft SQL Server Native Client cannont be found. Try the installation again using a valid copy of the installation packege 'sqlcli.msi'.' If I install the complete VS 2005 developer ed, this help to fix the issue?

|||

There is a standalone redistributable for SQL Server Native Client. The server portion of the setup installs it as a prerequisite as well.

|||

I have finished to install the Clien Components, I ran the Task Manager and end the process tree of the sqlserver and the explorer.exe and then start again the explorer.exe and ran the setup with this I can install the client components without message error.

Many thanks to all.

Marcos