Hello Phil,

Thank you for the detailed response.

Yesterday, I visited below two links and based on them we've now decided to migrate the package stuff into SQl stored procedure. Once again,...

Hello everyone,

I've resolved this issue. It was due to incorrect version of Coyzeroc tool at production server. After installing the correct version, the problem gets disappeared.

Thank you for the responses.

Thanks,

Ankit

Hello SSCrazy,

Thank you for the response.

Please know, I've resolved both these problems. Following are solutions,

1. I've resolved the first problem by selecting an option highlighted in following screen print.

2....

Hello Koen,

Thank you for the response.

So, you mean use Script task, which will pick the .csv file one by one from the specified folder, and use .Net SQLBulkCopy to push...

Hello Phil,

Thank you for the quick response.

Yes, the table structure is different for each SQL table.

Is there any way to achieve it dynamically using script component on Data Flow task?

Thanks,

Ankit

Hello Phil,

Thank you for the response.

After reading the following blog,

http://sqlblog.com/blogs/jamie_thomson/archive/2010/11/13/ssis-server-catalogs-environments-environment-variables-in-ssis-in-denali.aspx

and you suggested,

I require to create one project along with the 3 packages in it.

The folder path from where...

Hello Anshul,

Thank you very much for the quick response.

Package 1:

Please know, the client has many customers who will be supplying such bunch of CSV files to them.

Based on the version...

Hello Lowell,

Thank you for sharing the SSIS package.

You've used only the script task for entire work, actually we're not going to implement the solution in that way.

As per our implementation,

We've...

Hello Phil,

Thank you for the quick response.

For first point, I will re-confirm with customer that can we create the SQL script task that will first create the all tables to...

Hello Lowell,

Thank you very much for the response.

I'm also having the same type of requirements for this client as you specified.

I'm going to handle our requirement in more...

Hello Phil,

I'm really sorry, it's yourself only.

Instead of Phil I specified Chris in my previous reply.

Client has provided one PDF file that contains the details about each column for every...

Hello Chris and Jeff,

Thank you for the response.

The data type for each column of all 50 files will always be varchar (255).

The requirement is like the client would like to...

Hello,

To resolve this problem, I had deleted the existing destination component, it's connection from connection manager and then I recreated the FL component from scratch. And surprisingly it worked.

It seems...

Hello Phill,

Thank you for the response.

I've finally managed it with script component, wherein I replaced the column separator with vertical pipe and row separator as TAB character and managed to...

I did that but still no luck. Please advise any other options.