Have you tried using a format file with the BCP Utility?

You need to change the delimeter so that it does not import the "".

I have experienced issues with a 64 Bit Server.

What task(s) are hanging and what processes do they use?

Are you using VSS?

http://www.opcg.com/index.php/2009/03/17/visual-studio-the-selected-file-is-not-a-2005?blog=2

If you want all of the records of the Date Column to contain the exact same value for each date imnported then you could define a variable in the SQL...

Sounds like you need to store the value of the column that identifies what records to update in a package variable and then use variabole as an input parameter in...

You should add the column to the table.

You may want to add two columns, one to store the Date the File Created and another to store the Date Modified of...

Typically you would have a @MaxCounter or a hard code value.

I believe that you want to assign @Counter = 1.

The send mail task may not work for you.

I have used...

Sorry for any confusion.

The important thing is that you check the system tables to determine if the index exists. I mentioned this in a couple of post earlier today but...

Have you looked at the send mail task?

Create a Package Level Expression @Counter

Set the INtail Value to Zero

Right click on the For Loop COntainer and Choose Edit

Set the InitCount = @Counter

Set the AssignExpression Property to @Counter =...

You could use an Expression that is Counter for each file and is updated for each file that is read.

Then refer to the expression's value when you generate the e-mail.

If you decide not to use the BCP Utility which has it's advantages you may want to consider using the SSIS Import and Export Wizard.

One way to access this...

Oracle using the same concept as the later versions of SQL Server.

Please rtefer to the following link:

http://www.cryer.co.uk/brian/oracle/howto_orcl_rbai.htm