Will the folder have only one file? If so, just use a For Each Loop with *.xls...

what do you mean by a value?? Are you looking for something similar to this SQL statement below in ssis.

Select Convert(Varchar,Getdate(),109)

Probably my explanation wasn't as good as BLOG's post.. 🙂

I would possibly take the below approach..

1. using script task collect all filenames and their time stamps if not part of the fileName

2. Load into temp table and then...

for some reason, I was under a wrong impression that its much faster compared to Sub Query.. Thanks a lot for Correcting Me Guyz 🙂

I think its because of the Temp Table... Where are you creating the Temp table.I just see a Drop statement in your SQL code....

using a CTE instead of a sub query would improve the performance of the query

WITH CTE AS

(

...

So the problem Should with the Code column.. Try using the below Exp

(!ISNULL(Code)) && ((Consumption) >= "0") && ((Rate) >= "0") && ((TotalAmt) >= "0")

what are the data types of the columns?

As Zendada States you need to add a case statement bcz your syntax is correct but if its an Empty string it would have a len of -1 and returns...

You will need to write a script to get the list of all the files and then store them in a variable and later load into a table.. I am...

You can use an OLE DB Command Task to update the values..

Your Parametrized SQL should look like this

Update TABLENAME

SET Column1 = ?

WHERE Column2 = ?

Check this Example :...

I would suggest you to use a FEL with a script task that would check the number of columns and then move it to a DFT with the Help of...

Once you select the server and the Data Access mode as Table/View OR Table/view fastload.. Beside the Name of the table or view you should see a NEW button..A click...

Use a OLE DB destination instead and follow the same steps that you did for SQL Server Destination