import one table from one database to another database

if i have one table from database A, and i want to copy the table to database B, then how to do it in SQL server management studio express? is it i have to make sql query?

try

select * into databaseB.dbo.TableA
from databaseA.dbo.TableA

or go to database B and run

select * into TableA
from databaseA.dbo.TableA

This will not copy constraints only data.

if it will not work right click on database and from task select import or export and select source destination , table to copy and run created SSIS package.

|||

i don't try yet the query. anyway, i right click on the database but i don't find any task that saying select import or export?

|||

i don't try yet the query. anyway, i right click on the database but i don't find any task that saying select import or export?

|||

Right click on your database in Object Explorer and in menu select tasks and next import export, Sorry it does not work in Management studio express, nut if you have SP1 and integration developments studio installed you can do it inside it.

import flat file

I am trying to import a flat file using SQL Server Management Studio and am receiveing the error:

Error 0xc0202055: Data Flow Task: The column delimiter for column "Column 19" was not found.
(SQL Server Import and Export Wizard)

I would like to capture the rows that are causing the error and have the import continue. Am I able to edit the behavior somehow?

Thanks.

If I recall correctly; in one of the last steps of the import wizard you are asked to either execute the package immediately or to save it as a .dtsx file.

Chose to save it as a .dtsx files and the use BIDS to edit it according to your needs.

|||

Hi Rafael, thanks for responding. I get to the screen where it tells me that ' The package will be saved to the instance of the SQL Server Database Engine ...', but it doesn't allow me to choose the file extension. Yes, I'm very new at this.

Thank you again, I really appreciate your help.

|||

Hi, I was able to save the .dtsx file. Now on to BIDS.

Thanks.

|||

I've been trying to edit the package in BIDS but am not having success. I'm importing a flat file and am trying to write the records that do not get imported successfully to an error file. If anyone can help me out.....

Thanks.

|||

tantz wrote:

I've been trying to edit the package in BIDS but am not having success. I'm importing a flat file and am trying to write the records that do not get imported successfully to an error file. If anyone can help me out.....

Thanks.

You will have to tell us what you are not having success with first.|||

Well, I read that you can 'use the Error Output Page of the Flat File Source Editor dialog box to select error-handling options'. How do I do this? Thanks.

|||

tantz wrote:

Well, I read that you can 'use the Error Output Page of the Flat File Source Editor dialog box to select error-handling options'. How do I do this? Thanks.

On the data flow, you grab the red arrow of the flat file source and connect it to a destination (flat file, sql server, etc...)|||

Thanks Phil. I was able to connect it to a flat file, and am getting the same errors. Where can we find this file with the errors? Also, is there a way to make the package continue processing even when there are errors?

I really appreciate your time and help.

|||

Open the Flat file Source editor; go to the error output page and make sure all the values in Error and truncation columns are 'Redirect Row'. Tip You can Shift+ Select al of them and then use the 'Set this value to the selected Cells'. After doing that, make sure you connect the red arrow to a file or any other destination; so you can examine it later.

|||Hi, thanks for your reply.
I don't think I'm looking in the right place - can you tell me exactly how you're getting to the error output page. Thanks so much.|||When you double click on the flat file source, there is a button, "error output" or something like that.|||

Cool, I got it, but I still am not able to see the records. I've connected the flat file source with a red arrow 'flat file source error output'. What else am I missing? Anything with mappings? An error list is displayed at the bottom, but it has 0 errors, 0 warnings, 0 messages, but I know I am getting errors.

Thanks so much.

|||

Hi, I think I've worked out the error output, but I seem to have created a different problem. I am now getting a message 'cannot open the data file. the process cannot access the file because it is being used by another process'.

It's a .txt file. Nothing else is using it. I just ran something in SQL Server Management Studio using the same file and it works fine. Is it possible that I changed something in the .dtsx package when I was trying to get the error output to work?

If anyone can help me out -
Thanks.

import file

Hi All,
Is there any way to import a text file into a table in sql server 2005
prefarabley in its gui (MS SQL Server Management Studio)?
Thanks.
In Management Studio, right click on a database and select
Tasks, select Import Data. This will start up the SQL Server
Import and Export Wizard. For the Data Source, select the
Flat File Source and walk through the wizard from there.
-Sue
On 6 Nov 2006 13:29:00 -0800, "sara" <sarasara82@.gmail.com>
wrote:

>Hi All,
>Is there any way to import a text file into a table in sql server 2005
>prefarabley in its gui (MS SQL Server Management Studio)?
>Thanks.
sql

Import Data in SQL Server 2005?

I'm using SQL Server 2005 Management Studio Express, and trying to import data from an Excel spreadsheet into a new table. I'm used to doing this through Enterprise Manager in SQL Server 2000, but I'm not sure how to do it in the new interface. Is there a way to do a simple data import without also installing Business Intelligence Development Studio?

hi,

nope..

all this "stuff" has now be included in SSIS (integration service), not available in SSMSE as SQLExpress does not include the required runtime at all..

but you can perhaps interact with "linked servers" scenario and perform INSERT ... SELECT ...

something like http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=670748&SiteID=1

regards

|||Thank you!

Import an Access Database

I am trying to import an Access database and I am using SQL Server Express. The instructions say to

In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.

When I point to Tasks, the Import Data is not listed.

If someone can help. Should I be able to use the Import Wizard?

Thanks,

Dougins

Import/Export is not available on SqlExpress.

Integration and Interoperability Feature Express Workgroup Standard Enterprise Comments

Import/Export

|||http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx|||did this answer your question?

Import an Access Database

I am trying to import an Access database and I am using SQL Server Express. The instructions say to

In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.

When I point to Tasks, the Import Data is not listed.

If someone can help. Should I be able to use the Import Wizard?

Thanks,

Dougins

Import/Export is not available on SqlExpress.

Integration and Interoperability

Feature

Express

Workgroup

Standard

Enterprise

Comments

Import/Export

|||http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx|||did this answer your question?

Import Access File

Is there a way to import an access table into Microsoft SQL Server Express with Server Management Studio? I prefer not to use the upsize tool from access. Another option would be to import from a text file, if someone can explain how to do this.

Thanks

hi,

nope, this is not "available"... but you could use a linked server approach..

regards|||

Microsoft has an excellent tool for migrating Access tables: SQL Migration Assistant for Access. Try:

www.microsoft.com/sql/solutions/migration/access/default.mspx

If you just search the Microsoft site for SQL Migration Assistant for Access it will give you several links to follow.

Hope that helps.

Don Seydel

Import & Export disabled in Management Studio

I find that sometime the menu item "Import" and "Export" of the database popup menu in SQL Management Studio are disabled. Why and how can I enable them?

Thanks

Any suggestion is appreciated.

Import & Export in SQL 2005

I want to import and export data in SQL Server 2005, how can I do through in
Microsoft Sql Server Management Studio..
Thanks
Rogers,
In the SSMS Object Explorer window, alt-mouse-click (right-mouse click for
most of us) on a databasename, choose Tasks, then choose either Export Data
... or Import Data ...
RLF
"Rogers" <naissani@.hotmail.com> wrote in message
news:eSaZrkpgHHA.4844@.TK2MSFTNGP02.phx.gbl...
>I want to import and export data in SQL Server 2005, how can I do through
>in Microsoft Sql Server Management Studio..
> Thanks
>
|||I have a Standard Version, I can't see that options.
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:epVf49qgHHA.588@.TK2MSFTNGP06.phx.gbl...
> Rogers,
> In the SSMS Object Explorer window, alt-mouse-click (right-mouse click for
> most of us) on a databasename, choose Tasks, then choose either Export
> Data ... or Import Data ...
> RLF
> "Rogers" <naissani@.hotmail.com> wrote in message
> news:eSaZrkpgHHA.4844@.TK2MSFTNGP02.phx.gbl...
>
|||I have a Standard Version also. The Object Explorer is the window in SSMS
that shows servers to which you are connected and their databases, etc. It
says "Object Explorer" at the top of the window.
If your Management Studio is only showing a query window, hit F8 to cause
the Object Explorer window to open.
RLF
"Roger" <naissani@.hotmail.com> wrote in message
news:%23TepQHtgHHA.2332@.TK2MSFTNGP04.phx.gbl...
>I have a Standard Version, I can't see that options.
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:epVf49qgHHA.588@.TK2MSFTNGP06.phx.gbl...
>