There is no option available in FTP task as such but I guess with help of ftp commands it could be done.The ftp script to be executed in Execute Process...

Please refer below link

URL : http://www.microsoft.com/learning/en/us/certification/cert-overview.aspx

Hands-on in technology and product documentation is sufficient to take up certification.Also Microsoft provides lot of books and tutorials as well.

All the best.

SQL could be used in OLEDB command transformation inside data flow and at present there are no options for using query in OLEDB Destination component.

Hi,

Data of this kind could be broke down using split function available in VB.Net.Hence instead of using derived column transformation with substring function , same result would be obtained by...

For #5 set ForEachLoop container property ForceExecutionResult = Success so that loop will continue incase of failure

1.Check whether the connection manager retrieves value from configuration file.

or

2.Whether you have used variables in expression for connection manager.