Importing text File

I am trying to import a text file into Crystal 9. I have used text ODBC drivers, MS Assess type connections. Whatever I try, the first record is always skipped. Crystal is using the 1st record as a field label. The file is a straight ASCII file, 80 characters long per record. There are no field labels.

Any suggestions?You have no choice. All fields need label and CR identifies first record as field label.

Importing MySQL BLOB to MSSQL

Hi all!
I'm trying importing a MySQL database to my MSSQL server. I've donwloaded the MySQL ODBC drivers and I can connect succesfully throught a DSN to my MySQL server. Everything works fine EXEPT my BLOB field. I'm using a BLOB field for storing a binary file.

When I choose preview while importing my bob field is empty.

I'm desperate!

:eek:Viewing a BLOB is pretty much a waste of time. Use DTS or a linked server to move it, and life should be good.

-PatP

Importing data into SQL Server 2005 via ODBC

Hi

I've got an Ingres database of some 200 tables which I need to import
every night into SQL Server 2005 for use by Reporting Services. Most
of the tables will come across unchanged (a few need massaging to
handle time intervals correctly), but the Import Wizard only seems to
want to import one table (or more accurately query) at a time. I seem
to remember the old 2000 Import Wizard handled multiple tables - is
there any way of processing multiple tables in 2005, or must I resign
myself to writing 200 import packages in SSIS.

Chloe Crowder
The British LibraryChloe C (chloe@.mcrowdd.plus.com) writes:

Quote:

Originally Posted by

I've got an Ingres database of some 200 tables which I need to import
every night into SQL Server 2005 for use by Reporting Services. Most
of the tables will come across unchanged (a few need massaging to
handle time intervals correctly), but the Import Wizard only seems to
want to import one table (or more accurately query) at a time. I seem
to remember the old 2000 Import Wizard handled multiple tables - is
there any way of processing multiple tables in 2005, or must I resign
myself to writing 200 import packages in SSIS.

Are you looking at the Import Wizard in Mgmt Studio? I think you should
look into SQL Server Integration Services, for which you can create
packages in Business Intelligence Development Studio. (Although that is
as much I know about SSIS.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi Chloe,

Just had to do this today and it seems to work fine (although importing
multiple Excel sheets to multiple tables). After you select the Source and
Destination, there is a screen that asks to "Copy data from one or more
tables/views" or "Query" (not sure about the exact wording of the options
but something close). Then you can do mapping to destination tables/columns.
The last step is to execute or save as SSIS package.

If you do not see that option, check if you have the latest service pack. It
will be worth testing with SQL Server as Source, just to see if it has to do
with the driver for the source (I am confident you can import multiple
tables when the source is SQL Server).

HTH,

Plamen Ratchev
http://www.SQLStudio.com|||On Tue, 27 Nov 2007 19:13:10 -0500, "Plamen Ratchev"
<Plamen@.SQLStudio.comwrote:

Quote:

Originally Posted by

>Hi Chloe,
>
>Just had to do this today and it seems to work fine (although importing
>multiple Excel sheets to multiple tables). After you select the Source and
>Destination, there is a screen that asks to "Copy data from one or more
>tables/views" or "Query" (not sure about the exact wording of the options
>but something close). Then you can do mapping to destination tables/columns.
>The last step is to execute or save as SSIS package.
>
>If you do not see that option, check if you have the latest service pack. It
>will be worth testing with SQL Server as Source, just to see if it has to do
>with the driver for the source (I am confident you can import multiple
>tables when the source is SQL Server).
>
>HTH,
>
>Plamen Ratchev
>http://www.SQLStudio.com
>

Plamen

thanks for this. Importing multiple tables works well from SQL Server,
but with the Ingres server as the source the Copy data from one or
more tables/view option is greyed out, leaving only the option of a
single select statement in a query.

Ah well, I'll do it the hard way.

Chloe|||On Tue, 27 Nov 2007 22:59:18 +0000 (UTC), Erland Sommarskog
<esquel@.sommarskog.sewrote:

Quote:

Originally Posted by

>Chloe C (chloe@.mcrowdd.plus.com) writes:

Quote:

Originally Posted by

>I've got an Ingres database of some 200 tables which I need to import
>every night into SQL Server 2005 for use by Reporting Services. Most
>of the tables will come across unchanged (a few need massaging to
>handle time intervals correctly), but the Import Wizard only seems to
>want to import one table (or more accurately query) at a time. I seem
>to remember the old 2000 Import Wizard handled multiple tables - is
>there any way of processing multiple tables in 2005, or must I resign
>myself to writing 200 import packages in SSIS.

>
>Are you looking at the Import Wizard in Mgmt Studio? I think you should
>look into SQL Server Integration Services, for which you can create
>packages in Business Intelligence Development Studio. (Although that is
>as much I know about SSIS.)

Erland

I was rather hoping to, in effect, automate the creation of my SSIS
package with the Import Wizard, otherwise I need to do each import as
a separate task in SSIS.

Ah well, do it the hard way...

Chloe