Sure. Described as below:

Step 1: Add a Linked Server

Step 2: Using Open Query

But after reading your original post, which says you wish to manipulate data in the production server.

Be cautious....

Absolutely. But remember not to cross post.:-)

Absolutely.

Infact, I would recommend you post all your questions regarding Data Mining here

Santhi,

Check this out...

You have an aggreagte stored in UDM at Month level...how do you get the values at day level...

not possible...:-)

Nice question...EDM after a very long time..Thanks!!:-)

Please follow here

No activity:(

For every component found "Missing" a Script Task/component comes to rescue.:-)

like it!!

Still EST will solve your need:-)

A EST(Exec SQL Task) would solve your need

Saurabh,

I have worked relentlessly on SSIS. By far it has met all my needs any ETL or data staging developer can possibly think of.

These are two different ETL products.

SET DATEFORMAT mdy;

Nice...job well done:-)