Hi everyone,

Managed to solve it. Added a column to store the string I need and used it in bcp.

Thanks for all of your support.

Cheers!

Hi!

Thanks for your reply.

Yes my select query runs.

This is my select query

select 'LOAD DATA INFILE ''D:\load\dat\' + TableName + '.dat''' +

...

Hi buddies,

Thanks for your reply.

This sql statement works fine. I have tested it.

select 'LOAD DATA INFILE ''D:\load\dat\' + TableName + '.dat''' +

...