While reading the data from the file read all the columns as string and then use the data flow transformation tools like "Data Conversion" to convert to int/float .

Basically its...

Is it a variable length file and what is your column delimiter?

May be it is an authentication issue . Please test by creating a simple sp that inserts data into the table and schedule it as a job and test if...

I am sorry I am busy today with some production errors but please go trough this example from

http://www.sqlis.com/post/The-Script-Component-as-a-Transformation.aspx

Remember your Input is just one column here.

Are you testing it on the same server? check your configuration files, may be they both are pointing to different servers.

Probably There are spaces after your column1

use the following statement

UPDATE TABLE

SET COLUMN1 = RTRIM(LTRIM(Column1)) + ']'

Create a data flow task and read each individual row (at this stage do not consider column delimter) Then create a script component task as a data transformation...

Thanks for your reply, by unions we are just assuming the no of regions to be fixed, but as i said the regions might grow in future as of now...

No the no of columns are not fixed so I would prefer my reporting with matrix where the regions might grow in time. Also I have examples of using one...

There is a company's table where I get the total of the company count group by regions and then there is a overdue company table where I get the count...

Thank You that works

probably the problem i stated is not very clear, the user has SHOWPLAN permission just that when an index is created and while I execute as a user it throws...

It is occuring in SQ2005 and I am logging in as sa with all privileges.

Before the exec as user = 'aparnak' I am using the following statement GRANT...

Thank You I will give it a try.