For this scenario we can create a trigger to flow the process instead of using SSIS package.

In the file connection manager ..once you select the file where you want to extract.Then you have option as set the delimiter as fixed length.so your data in file...

Its all about the report is not updated properly.

If you have any unique column in that table means add that column in your select statement result and in the group properties add that unique column to order by.You...

Yes you can use table2 has source table 1 is look up table. so that you can get the out put of 4,5 in the non matching output.

Gr8 let me try this

Hi,

Its not neccesary to install the oracle clinet in the local machine to conact the oracle database through SSIS.

Hi ,

I have suggestion for this senario.

You are not able to insert the record by using oldeb destination.

Step:1 you rae creating a table by uisng execute sqltask.

Step:2 then you use...

Hi,

The issue is not other person open the log file which you try to open.

1)If you write a log file for package execution result.and trying to open the file with...

1) Use for each loop conatiner to get the file available in the source.assign the file name path into one variable.Every time the loop execuet and provide you the new...

You option in the FILE SYSTEM task where you create a folder or file.

Yes only FTp Task help yopu in this senario.If you want to make speed of download and upload the file to ther server better you zip the file and do...

Instead of using Lookup task, you can use conditional split and give the condition as isnull(columnname) or Column is null.so that you can able to insert the null values to...

Its really a starnge issue in SSIS.

Yes,

ADO.NET --> uses ActiveX Data Objects for .NET

OLE DB --> uses COM interfaces (in my opinion the easiest and the fastest to work with)

While using ADO.net connection in the...