I am facing the same issue, but I am not able to see these option on my local machine's MSDTC.

FileName VARCHAR(255)

We are saving mapping in below format. The other approach is saving it in vertical format.

File NameCol1Col2Col3Col4

File 1.xlsField1Field2Field3Field4

File 2.csvField1Field3Field2Field4

File 3.xlsField4Field3Field2Field1

File 4.tabField2Field4Field3Field1

The only constraint we faced here is using mapping how...

that pretty awesome Koen, but do you have any sample for reference.

need expert comments

you can do this by declaring variable. check this post - http://stackoverflow.com/questions/3888170/ftp-connection-string-using-expression-in-ssis

In script component you have to initialize the variable by using DTS.Variables class. you can declare a variable within script component and assign the value as far my knowledge there...

Thank you L' Eomot Inversé , but as per our requirement a separate history table for each attribute table could result in a massive amount of table. Additionally with such...

sorry friends it my bad....i should have frame the question correctly...but for now I think i found the solution for my problem...sorry for the inconvenience

How do you want us to help? - need help to optimize the query.

Can you drop this proc and never use? - not possible

If not, what are the...

please check whether you have configured correctly database mail account in the same profile?

this is one of the worst problems in SQL Server: you can only change only if there is no dependency on objects

Grant - Can you please guide on which extended events

It seems like you are not authorized to create login using deault schema. check the permissions you have on the server.

OMG! so many subqueries in one query. it's gonna die :w00t:!