@skcadavre:

Your solution will work on SQL Server, but not on Access. The getdate() function doesn't exist there.

As the OP proposed, the function DATE() should be used. However, I'm not familiar...

In the For Each loop, you can set the property FileSpec to a filetype, so that the loop only takes the file of that specific filetype. For example, if you...

It's hard to do that directly in the dataflow, so I would suggest that you read all your data first and then write it to some sort of staging table...

When I read your recommandation for refreshing the metadata of the data source, I get the feeling that in the case of an OLE DB Source, you select the table...

Thanks for the info.

Shouldn't the order by 1,2,3, instead of 1,1,1?

I think that if you give them all the same order, they are evaluated at the same time, and of course no row...

Thanks for the link!

Nice question. I didn't know that constants (like 1) could be placed after CASE, so I definately learned something today.

Doesn't Amazon ship to Indonesia?

Regarding the first problem: that's quite odd that the package still fails after removing the tasks. But, with SSIS and its underlying metadata, you never know. Without the exact error...

Sorry, I was wrong. (In my mind it was OK, but I wrote it down incorrectly :-)).

If you copy entire packages or if you deploy them to other systems, the...

SSIS uses internal ID's for its connection managers under the hood.

Normally, copying packages will not harm your connection managers (I do it all the time), but it will screw up...

What is the purpose of the package? What tasks/data flows/components are present in the package?

chaudharyabhijit (5/21/2010)

---

Hello,

The expression is working and everytime i run the data flow i do see a new file come up with the current date. Now i have placed this data...

It seems it is has something to do with the logging.

Check if the connection manager used to log is configured correctly.

(it should point to a specific log table in the...