Do you see valid values when you preview you the data from the Flat File Source .. If yes, Then also check the data while importing by using a data...

You will need to use a Derive Column transformation after the Flat File source

In derived Column add a new column and In the Expression field you will need to write...

I would suggest using a SELECT that CELKO suggests as updating is always expensive..But if you still want to below is the code

UPDATE TableName

SET ColName = CAST (CAST(ColName AS FLOAT)...

you don't need to do that for all manually, use an update statement.. to update all values with 'E' in it using a case statement with Patindex

Do you want to read the Complete data in that field or just the 30000 characters ? If you want to read complete field i might be able to...

I believe you are using For Each loop to loop through the files.. So all you need to do is

1. Extract part of the FileName from the Filepath using Substring...

Drag and drop the Parameter on the Header .. It will display the value at runtime

Link below will help you create multiple sheets.. I have used the same method Raunak Suggested in the past and i think its a good work around if cannot use...

In look up you have Columns Tab where you map the Lookup Columns and also select the desired output columns where you can select the columns to be updated..

you will have to use a lookup to find the matching entries and then map the Lookup Match Output to OLE DB Command transformation Task to update values passing...

I would suggest you to bring the values in as Varchar and convert them into Date using the Convert Task.. Also, change IMEX= 1 in the excel properties.. so that...

Firstly it needs to be C:\\ for it to work regardless of the scope as the backslash always requires an escape character before it i.e., "\"

You don't need to update the view unless you have added new columns to your table, which you want to display using...

It has to be done dynamically.. Let me ask you this 1st. how many weeks data do you want to display.. is it monthly or specific number of weeks from...

you can definetly use a function in a join but without variables.. in case you want to use variables try using Dynamic SQL..

DECLARE @sql NVARCHAR(3000)

SET