Import from sql 2000 to sql 2005

We keep running out of space due to the temp file getting so large on the
source server. Is there any way to prevent this ?
ThanksWhat exactly are you doing?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Ray Brown" <RayBrown@.discussions.microsoft.com> wrote in message
news:A52B9428-5F2C-4DC9-8447-F6B6B440D5F1@.microsoft.com...
We keep running out of space due to the temp file getting so large on the
source server. Is there any way to prevent this ?
Thankssql

Import from sql 2000 to sql 2005

We keep running out of space due to the temp file getting so large on the
source server. Is there any way to prevent this ?
ThanksWhat exactly are you doing?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Ray Brown" <RayBrown@.discussions.microsoft.com> wrote in message
news:A52B9428-5F2C-4DC9-8447-F6B6B440D5F1@.microsoft.com...
We keep running out of space due to the temp file getting so large on the
source server. Is there any way to prevent this ?
Thanks

Import data from Excel?

Hello,

I have an Excel spreadsheet that I am loading data from and I want to prevent SSIS from making assumptions about the data contained within the spreadsheed and to just treat every column as a string (i.e. Unicode string [DT_WSTR]). How is this done?

I know I could do a conversion once the data is loaded, but I am wondering if there is a way to specify this in the Excel Source settings without having to add a Data Conversion task to the Data Flow.

TIA...

As far as I know, this cannot be done. You are allowed to set data types in Flat File Sources and delimit them by a comma, though.

Maybe you could export the excel file to comma delimited and then import as a Flat File.

Just a suggestion,

Mark

https://spaces.msn.com/mgarnerbi

|||

You could experiment with the following settings:

Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/ImportMixedTypes