Hi,

Even i want to know what is sp_procedure_params_managed

and

spt_procedure_params_return_values_managed

so if you come accross any answer, please post it.

Thanks

Viji

in the file system task -

--> souce connection click new connection

--> usage type change into existing folder.

regards

viji

Thanks a lot.

Will try to implement the same. But i'm from database side so don't knw much about .net coding. i'll try to take help from others. ...

the problem is there with the excel.

while coming from my excel source it is coming as 23.000000001 instead of 23.01 and sometimes it comes as 23 instead of 23.01. ...

especially if it is 8.01, 234.01 then it takes this as a whole number

if it is 8.06 then it is rounding it to 8.05 and sends to error output which...

hi

sorry for the delayed reply

i'm checking like this in conditional split

FLOOR((DT_NUMERIC,7,2)[stock onhand qty]) != (DT_NUMERIC,7,2)[stock onhand qty]

but it redirects corrctly some times but not always.

some times it rounds up...

using any of the transformations or data conversions or mathematical functions in SSIS

Thanks Phil and Lowell it works in SQL Function,

but i would like to know is there a way to do this without calling sql function in SSIS?

once again thanks for...

Hi,

Thanks a lot. setting extended properties to IMEX=1 works, provided when i set all my excel columns meta data to text.

regards

viji

Hi Rick Todd,

thanks for your suggestions.

wil try to do the same.

regards

viji

Hi Rodd,

thanks for your info.

wil try to do the same.

regards

viji

Hi Jack,

Now its working fine with initial catalog itself. There was a difference between the database name and the name what i was getting into the variable.

Because of that...

Hi,

thanks for your reply.

before doing it for connection string i tried it for initial catalog only.

there also i'm getting the same problem. its because of SSIS forgetting the password.

even...

Hi,

ISNULL function works for character.

numeric fields which is blank are not thrown into error output.

thanks,

regards

viji

hi,

i tried something like this

select sum([Client Tbl Dim Calendar].[Day Week Id].&[0828]:[Client Tbl Dim Calendar].[Day Week Id].&[0824],[Measures].[Quantity Sold])

from [DSVClientAdmin]

i'm getting error :

Executing the query ...

Parser: The statement dialect could not...