Hello Frank,

Thank you for your reply.

But, I did not understand properly.

Could you explain me a bit in detail about where can I write this query or connect to a linked...

Hi,

Did you google it by any chance? There are many links available that mention the advantages of SSIS 2005 Packages over DTS 2000 Packages.

Some of the links that I found...

Hi,

Oh. So, you do not have a Solution file in BIDS.

If you just have your packages in MSDB, then I also do not know the easiest way to do this.

Kindly...

Hi,

I also work with around 15 packages and I have to move them from development to test and from test to production. The way I handle this is by creating...

Hello Jack,

I am not able to see the results because of an error in the destination.

The error message is:

[OLE DB Destination [312]] Error: An OLE DB error has occurred. Error...

Hi,

I am also not an expert in this, but I guess you will have to use Fuzzy Lookup Transformation first to know which data is bad and which is good...

Thank you so much for all your replies.

The business logic was that there are two units associated with a single machine. So, the number fields were units that I...

Hi,

I guess you might be knowing about Send Mail Task Editor (when you double click on send mail task).

But before that, if you want to check whether your email, port...

Hi,

I did not get your question exactly, but as far as I understood, you are asking how to connect to different excel files everytime. I guess it means, different excel...

Hi,

I usually do this almost everyday at my job place. I have to get the data from different excel files in one package. I use a very simple method. In...

Hello Jack Corbett,

Thank you so much for your response.

Yes, it is working now. I had to go to the Properties window of my SQL Server Destination and change the...