DTS load

New to SQL Server :(
load a txt file to SQL
there is a field, data type is numeric (13,6).
But in the file, it is like this: 9999999999999
How do I add the decimal points to make it: 9999999.999999??
Thanks a lotOriginally posted by qingbo
New to SQL Server :(

load a txt file to SQL

there is a field, data type is numeric (13,6).
But in the file, it is like this: 9999999999999

How do I add the decimal points to make it: 9999999.999999??

Thanks a lot

Add an Execute SQL Task object to the package and insert code something similar to this:

UPDATE tablename
SET ColumnName = ColumnName / 1000000.00

Where ColumnName is the numeric(13, 6) column defined in the table.

Hope this helps.

DTS jet oledb:engine type

What does jet oledb:engine type = 35 mean? I believe it means Excel file.
Where can I get a list of all the engine types?
Tnx in advance
JoeHave a look at this
http://support.microsoft.com/default.aspx?scid=KB;EN-US;230501
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org|||Thanks Allan:
We are close...look here:
http://www.thecoffeeplace.com/om/aaaaaagl.html
This is a list and it talks about values of 10,11,12...70
But not 35. The page you gave me only has 1-5 which the I listed above also
has 1-5, but not 35?!
Am I missing something in reading the page you gave me...?
tnx
Joe
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:VA.00000044.0158986e@.no-spam.sqldts.com...
> Have a look at this
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;230501
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>

DTS Global Variable Variant Type Mismatch

I am trying to declare a global variable in a DTS package for passing the recordset to the next stage Active Script . After declaration of the Global Variable and selecting datatype of the variable as OTHER ( Variant ) , when I try to save the DTS Package changes , it throws a Type Mismatch Error .

:confused: Please help me out .

Thanx
Arnie .You have to execute the package or otherwise cause it to set the type of the variable to what it's going to use (for recordsets it is 'dispatch' but you can't set it manually). Once the type changes, you can save it.