Hi,

In EXCEL Destination, you can create teh excel at run time-

Sample code-

CREATE TABLE `Excel Destination` (

`Col1` LongText,

`Col2` Long,

)

After...

Hi,

Please find the steps to handle the issue:-

1. First you should a Dataconversion to get it in a proper format.

2. Use the Aggregate Task to do the SUM for the...

Hi,

You can craete the Linked server in you SQL DB and use that for creating your connection manager in SSIS.

But while dumping the data in Oracle, may create some DataType...

Hi,

Building a package is a standard Practice. When you deploye your package from Dev environment to Production environement, you should build your package, which will craete the .msi file in...

Hi,

If the file is in the same folder, you can give the extension as *.* while configuring your Foreach Loop container.

Regards,

Chandrashekhar

Hi,

I would suggest to go for a temp table.

Create a temp table. Store teh source data in your temp table.

After this there are two approaches-

Approach1:-

After the dataflow task, use...

Hi,

Please send the screenshot of error message.

Suggestions:-

Please check the file format and the delimeters.

Please check the source data as well.

Regards,

Chan

Hi Dilip,

The design basically depends upon your requirement and keeping that in mind you need to decide.

In your current scenario - I would suggest to go for the second approach...