Can I send XML files?

If yes How?

Any inputs

Let me know if you are able to setup a connection propertt like this and manage to get access to different FTP sites with same/different logins.

Hello,

Actually my requirement was to process files that are not processed. I will delete such processed files which are stored in a table after successful processing.

I have written some logic...

Hi Cozy/all,

Can you post a sample snippet of script task reading data like userid/password/ipaddress from some flat file and using these as variables in the code.

Instead of declaring environment variables.

Rgds,

Seetesh

This is what I had done

Dim f As String

For Each f In System.IO.Directory.GetFiles(path)

...

Priya,

Edit your first post and put the right answers there.

Rgds,

Maybe you can write a SQL Task that calls a stored proc which will do the count of records inserted in the Daa Flow task and populate the results of...

I am writing a script that will delete the files on the local drive.

Dim path As String = "C:\aadelete"

...

Yup. Will post my code for your reference.

5 Pint of beer to you from my side for this solution. Working on it now to make it work else I will have nightmares if this code goes live...

Works with dbtimestamp but not with dbdate which is what I am surprised.

Sorry. Missed this point

Set the Option to Ignore Failure in the Error Output Tab of Derived Column Transformation.

There is a configure Error Output button in Derived Column Transformation Editor.

In...

Actually that is part of the small trial I did for receiving files from our ftp server. File size is 8 to 10 MB. But all are in .gz format...

did you try this solution?