No it didn't work.

Even in VS in control flow I am getting this error (Red x mark for data flow connecting to DB2) but able to execute succesfully in VS...

I didn't get you. Can u explain in detail.

Once I close my package and try to open again in VS also I am gettin the same error (Cannot acquire connection)...

Hi,

I just want the rowcount to be captured in log file(.txt file) for reference. So in this case,my execute SQL will not fit in. Right?

Thanks.

Can u pls. detail me the steps involved.

Performance perspective which would be better?

1. Using script task

2.Using script component

3. using insert SQL

4.Using event handler

Hi,

I use Row count transformation and get row count in a variable. I need this variable to be logged in log file for later verification.

So let me know if...

Hi,

Duplicates due to 2 reasons:

1. Duplicate rows in flat file- source

2. Trying to insert existing row into destination SQL

Step I followed:

1.Temp table(same as destination but without PK),removed duplicates and then...

Hi,

I am using SSIS package for exporting.

Well in this I can allow my audit file to grow in size. If I wanted to delete last month audit info. alone and continue with current month. How is...

hi,

  One solution to buffer size problem as listed in microsoft is available.

http://support.microsoft.com/kb/281517 .

You can try changing the Registry properties to solve the problem

Cheers,

Arthi.