Changing the job is not an option here, but I can do some work in the ETL field remotely if it will get me on. The problem in this case...

Thanks for your reply,

this sounds as the most natural way, but I don't want to change my job at this moment, so this is not an option for me....

FYI

Another great articles from this site!

http://www.sqlservercentral.com/stairway/72404/

Hey someone else wants to share learning sources .. ?

Thanks,

currently I'm reading this one http://msdn.microsoft.com/en-us/library/bb522607

as a starting point..

Hey all,

the cause of this issue looks like the "$(" and "($" in the text value... it works when replaced with space between them...

Can someone explain it to me...

I would ask something different ..

How can I preview the statement which is executed by the "Execute SQL Task" directly from the File Connection associated with the task?

Thanks,

Nikolay

Here is the log generated from MSDT in debug mode:

Executing the query "" failed with the following error: "". Possible failure reasons: Problems with the query, "ResultSet" property not set...