Hi,

Your requirement looks interesting.

But the 'amt+sign' is still returns string type and I guess derived column can not type cast it to decimal type.

I suggest instead apply /100 on amt...

You can sort the data in 2 ways

1. sort the data in database and then apply the Issorted and sortkey position on the source adapter which comes before any transformation...

Hi,

I know its too late response:-) But I have seen this post for the first time.

What I understood is that he wish to convert customer no to INT, in derived...

Hi,

You need not use FROM TABLEX twice which is redundant and also makes the query unclear.

Whatever Ninja suggested works well.

Regards,

Durga

Hi,

Its always better to store only the path i.e. file location or URL of the image rather than the image itself by using FILESTREAM.

So go by VARCHAR() to store the...

Thanks Andy for posting such a useful article!!

Hi,

After the @rowcount > 0 constraint, add a Send Mail Task to communicate to relevant people.

Alternatively you can use a Script Task to send the notification as well as attachments...

Dear Rob,

I think I got the solution.

The approach we have to follow is to use Foreach loop container with Foreach ADO Enumerator and a Data Flow Task inside the Foreach...

Hi rgtft,

Its a master data mart table which contains source, destination tables and respective primary key columns.

The requirement is to transfer data from source table to destination table...

Dear Russel Loski,

You are absolutely correct!!

Thank you, it helped me to resolve the issue.:-)

Regards,

Durga

Thank you Vishal..Very useful information.

I appreciate your patience in compiling this document!!

One of the possible reasons for this error is,

Your SSIS package may contain an dataflowtask trying to load data into a table having primary key without cleaningup the unwanted data...

Hi ,

I too face similar question with SSIS sql server table configurations.

I could create sql server configuration table easily for development instance.

To UAT environment, I have changed the connection...