DTS scheduling and float problem

Hi
I have some DTS-package that import textfiles. When I run
then manually everything works fine, but when i schedule
them the fields containing floatvalues is becomming
integers instead. Any one who know whats the problem is?
/AnettHi,
Inside the data Transformation task, change the destination field to Float
data type inside the package.
Thanks
Hari
SQL Server MVP
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:051c01c54019$a2377270$a401280a@.phx.gbl...
> Hi
> I have some DTS-package that import textfiles. When I run
> then manually everything works fine, but when i schedule
> them the fields containing floatvalues is becomming
> integers instead. Any one who know whats the problem is?
> /Anett
>

DTS scheduling and float problem

Hi
I have some DTS-package that import textfiles. When I run
then manually everything works fine, but when i schedule
them the fields containing floatvalues is becomming
integers instead. Any one who know whats the problem is?
/Anett
Hi,
Inside the data Transformation task, change the destination field to Float
data type inside the package.
Thanks
Hari
SQL Server MVP
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:051c01c54019$a2377270$a401280a@.phx.gbl...
> Hi
> I have some DTS-package that import textfiles. When I run
> then manually everything works fine, but when i schedule
> them the fields containing floatvalues is becomming
> integers instead. Any one who know whats the problem is?
> /Anett
>

DTS scheduling and float problem

Hi
I have some DTS-package that import textfiles. When I run
then manually everything works fine, but when i schedule
them the fields containing floatvalues is becomming
integers instead. Any one who know whats the problem is?
/AnettHi,
Inside the data Transformation task, change the destination field to Float
data type inside the package.
Thanks
Hari
SQL Server MVP
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:051c01c54019$a2377270$a401280a@.phx.gbl...
> Hi
> I have some DTS-package that import textfiles. When I run
> then manually everything works fine, but when i schedule
> them the fields containing floatvalues is becomming
> integers instead. Any one who know whats the problem is?
> /Anett
>sqlsql

DTS Olap Task error

DTS Olap Task, when i execute a package containing an Olap Task from the Enterprise Manager, it runs ok, but when i schedule this task, it fails. That Olap Task process a cube, updating incrementally its dimensions. When this Task need to process a dimension, it fails and the error is

Error Source: dst_flia_prodto.espesor
Error Description:RECORD=1, ERROR=CANTCONVERTDATA, COLUMN=0, NAME=espesor
Error code: 80040076
\Error Help File:
Error Help Context ID:1000440

Dimension 'dst_flia_prodto.espesor' Execute : SELECT DISTINCT "dbo"."dim_familia_producto"."espesor", "dbo"."dim_familia_producto"."espesor" FROM "dbo"."dim_familia_producto"
Error = 1 (00000001), Description = 23/08/2002 08:02:04 a.m. 3804 Data source provider error: Errors occurred while reading one or more columns; Time:23/08/2002 08:02:04 a.m.

But when i run this task from the enterprise manager, it succeeds.Have you checked the user permissions under which the SQLServerAgent is running? The agent needs to have adequate permissions to execute the task...
hth,
Michael|||Originally posted by mhweiss
Have you checked the user permissions under which the SQLServerAgent is running? The agent needs to have adequate permissions to execute the task...
hth,
Michael
Incremental process of other dimensions works fine. The following log could be a good example :
28332 Initiating transaction in Database 'dm_gego'
28332 Processing Dimension 'dst_mercados' Start time: 08:42:32 a.m.
28332 Process information for Dimension 'dst_mercados': An incremental dimension update is performed
28332 Initializing Level 'Unidad Negocio'
28332 Initializing Level 'Sector Mercado'
28332 Initializing Dimension 'dst_mercados'
28332 Dimension 'dst_mercados' Execute : SELECT DISTINCT "dbo"."dim_mercados"."direccion", "dbo"."dim_mercados"."mercado", "dbo"."dim_mercados"."unidad_negocio", "dbo"."dim_mercados"."sub_unidad_negocio", "dbo"."dim_mercados"."sector_mercado" FROM "dbo"."dim_mercados"
28332 Dimension 'dst_mercados' Execute : SELECT DISTINCT "dbo"."dim_mercados"."direccion", "dbo"."dim_mercados"."mercado", "dbo"."dim_mercados"."unidad_negocio", "dbo"."dim_mercados"."codigo_unidad_negocio" FROM "dbo"."dim_mercados"
28332 Dimension 'dst_mercados' Execute : SELECT DISTINCT "dbo"."dim_mercados"."sector_mercado", "dbo"."dim_mercados"."codigo_sec_mercado" FROM "dbo"."dim_mercados"
28332 Completed Processing Dimension 'dst_mercados'. End time: 08:42:33 a.m. Duration: 0:00:01 Rows processed: 101
28332 Processing Dimension 'dst_clientes' Start time: 08:42:33 a.m.
28332 Process information for Dimension 'dst_clientes': An incremental dimension update is performed
28332 Initializing Level 'Cliente'
28332 Initializing Dimension 'dst_clientes'
28332 Dimension 'dst_clientes' Execute : SELECT DISTINCT "dbo"."dim_clientes"."grupo_economico", "dbo"."dim_clientes"."cliente" FROM "dbo"."dim_clientes"
28332 Dimension 'dst_clientes' Execute : SELECT DISTINCT "dbo"."dim_clientes"."grupo_economico", "dbo"."dim_clientes"."cliente", "dbo"."dim_clientes"."codigo_cliente" FROM "dbo"."dim_clientes"
28332 Completed Processing Dimension 'dst_clientes'. End time: 08:42:34 a.m. Duration: 0:00:01 Rows processed: 4704
28332 Processing Dimension 'dst_flia_prodto.ancho' Start time: 08:42:36 a.m.
28332 Process information for Dimension 'dst_flia_prodto.ancho': An incremental dimension update is performed
28332 Initializing Dimension 'dst_flia_prodto.ancho'
28332 Dimension 'dst_flia_prodto.ancho' Execute : SELECT DISTINCT "dbo"."dim_familia_producto"."ancho", "dbo"."dim_familia_producto"."ancho" FROM "dbo"."dim_familia_producto"
28332 Data source provider error: Errors occurred while reading one or more columns; Time:24/08/2002 08:42:37 a.m.
28332 Data source provider error: Errors occurred while reading one or more columns; Time:24/08/2002 08:42:37 a.m.
28332 Processing Dimension 'dst_flia_prodto.ancho' failed. No changes have been made to the database.
28332 Rolling back transaction in Database 'dm_gego'