thank you again cphite for coming back...

i can't agree more with your advice of not going by the credentials in the url option..it is definitely a stupid solution..(despite finding...

in addition to cphite's reply, i request other forum members also to help out if anyone has a work around please..

thanks v much for taking time out in replying..(sorry for my un-formatted post previously..i've now formatted it and slightly modified a couple of lines in the first para)

and yes, you've...

it's a nice article. thanks.

i use the Data Generation Plan (DGP) feature available out of Visual Studio. it's much easy and no script-writing..any pros of using cross joins over DGPs?

Hi Matt,

I've implemented this thing as below:

In Data Flow Task, I've used two aggregate transforms which would give the sum of the floating/decimal field (say gross sales). These values are...

Hello Matt,

You're forgived 😉 yet, you still seem to be an expert 🙂

Coming to the topic...below i've tried to explain the issue to it's brevity...

There are two systems...source - sql...

Matt,

Thanks for your answer. I'm using SSIS 2008. I tried the article given in the link you mentioned. And to an extent, it can be used to solve my issue....

Can anyone please help?

Can anyone please reply to this?