DTS Fails

This summary is not available. Please click here to view the post.

DTS Date Problem

I have a DTS package that imports from a text file into SQL 2k SP3. I am trying to insert a field (along with the imported fields) during the DTS execution that will be the current date. Does anyone know of a way to do this? I really didn't think I should have to schedule a seperate job to UPDATE each record with the current date...

Make sense?Make a datetime column in the imported table default to getdate().|||Originally posted by joejcheng
Make a datetime column in the imported table default to getdate().

hehe, thanks. That's what I was trying to do, but for some stupid reason I wasn't putting the () on the end of getdate.

Thanks

dts conversion error

I have a dts package that imports data from a comma delimited .csv file.

I'm getting a conversion invalid for datatypes on column pair 1 (source 'col0012' (DBTYPE_STR), destination column 'latitude' (DBTYPE_R8)).

So, the source file is populated as a string for 'col002' and I have that field specified as a float within my table. Float is the correct type for the value.

How can I make the conversion correctly during the dts execution.

Thank you.do you have any empty strings in the source file going to the float column?|||Also - does your CSV include column headings and, if so, have you ticked the box in the DTS to let SQL Server know that?sql

DTS and Excel 2003

We have a DTS package that imports data from a client's Excel file. Previously our client was using Excel 2000, but recently they upgraded to Office 2003, and now suddenly when I try to view the transformation task properties I get a Jet Database Engine error: "External table is not in the expected format".

Everything else with the file appears the same (layout, formatting, etc.).

Any suggestions?

I have the same problem. Did you ever received suggestions or a solution. I would be happy to have the answer.

Thanks

DTS and Excel 2003

We have a DTS package that imports data from a client's Excel file. Previously our client was using Excel 2000, but recently they upgraded to Office 2003, and now suddenly when I try to view the transformation task properties I get a Jet Database Engine error: "External table is not in the expected format".

Everything else with the file appears the same (layout, formatting, etc.).

Any suggestions?

I have the same problem. Did you ever received suggestions or a solution. I would be happy to have the answer.

Thanks

DTS and decimal issue

I am importing a table from our ERP system using a DTS. THe table imports fine. The only issue that I am having is that a decimal field in our ERP system can be for example 105.1275, but when it gets inported to sql the number is 105.1270.

What could possibly be the issue and sollution for this. All help is appreciated.Ummm... what's the source platform of the data and the destination platform?

That'll learn you for using DT...uh...I can't say it...

Did you look at the transformation? Waht's the DDL of the source and destination look like?|||Check that the precision/length settings for the destination field is correct.

DTS

Hello,
I want to imports text file having Header and detail sections. Both Header
and Detail sections have different number of fields and different field
separators.
How can i imports such a file using DTS
Thanks
read the file twice, filter the header records in one process to a temporary
table, process it again for the details again to a temporary table. process
the temporary tables(s) again to scrub (validate the data) to where ever you
want.
Nik Marshall-Blank MCSD/MCDBA
"kailux4" <kailux4@.discussions.microsoft.com> wrote in message
news:CA3AA9AF-5FEE-40D7-84B1-54BE55360E64@.microsoft.com...
> Hello,
> I want to imports text file having Header and detail sections. Both Header
> and Detail sections have different number of fields and different field
> separators.
> How can i imports such a file using DTS
> Thanks

DTS

Hello,
I want to imports text file having Header and detail sections. Both Header
and Detail sections have different number of fields and different field
separators.
How can i imports such a file using DTS
Thanksread the file twice, filter the header records in one process to a temporary
table, process it again for the details again to a temporary table. process
the temporary tables(s) again to scrub (validate the data) to where ever you
want.
--
Nik Marshall-Blank MCSD/MCDBA
"kailux4" <kailux4@.discussions.microsoft.com> wrote in message
news:CA3AA9AF-5FEE-40D7-84B1-54BE55360E64@.microsoft.com...
> Hello,
> I want to imports text file having Header and detail sections. Both Header
> and Detail sections have different number of fields and different field
> separators.
> How can i imports such a file using DTS
> Thanks

DTS

Hello,
I want to imports text file having Header and detail sections. Both Header
and Detail sections have different number of fields and different field
separators.
How can i imports such a file using DTS
Thanksread the file twice, filter the header records in one process to a temporary
table, process it again for the details again to a temporary table. process
the temporary tables(s) again to scrub (validate the data) to where ever you
want.
Nik Marshall-Blank MCSD/MCDBA
"kailux4" <kailux4@.discussions.microsoft.com> wrote in message
news:CA3AA9AF-5FEE-40D7-84B1-54BE55360E64@.microsoft.com...
> Hello,
> I want to imports text file having Header and detail sections. Both Header
> and Detail sections have different number of fields and different field
> separators.
> How can i imports such a file using DTS
> Thanks