Monday, February 27, 2012

HELP!

Hi everyone.
I got som textfiles that I have to load in to the server,
I've done that with DTS package. When I run the package
manually everything works fine but when I schedule it the
float numbers becommes integers.
Manually 2.2 in the textfile becomes 2,2
in the schedule 2.2 in the textfile becomes 22...
Anyone that know whats the problem is'
/AnettHi,
In the Data Transformation Task, click the Transformation and change the
format of the column to Float and save your package.
Thanks
Hari
SQL Server MVP
.
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:10bc01c541b4$810abb10$a401280a@.phx.gbl...
> Hi everyone.
> I got som textfiles that I have to load in to the server,
> I've done that with DTS package. When I run the package
> manually everything works fine but when I schedule it the
> float numbers becommes integers.
> Manually 2.2 in the textfile becomes 2,2
> in the schedule 2.2 in the textfile becomes 22...
> Anyone that know whats the problem is'
> /Anett|||The format of the column is already float. Any other ideas?
/Anett

>--Original Message--
>Hi,
>In the Data Transformation Task, click the Transformation
and change the
>format of the column to Float and save your package.
>Thanks
>Hari
>SQL Server MVP
>..
>"Anett" <anonymous@.discussions.microsoft.com> wrote in
message
>news:10bc01c541b4$810abb10$a401280a@.phx.gbl...
server,[vbcol=seagreen]
the[vbcol=seagreen]
>
>.
>

No comments:

Post a Comment