Hi Asita,

In many of my packages, I have used Send Mail Task.

I had referred to this website for setting the Send Mail Task;

http://agilebi.com/cs/blogs/jwelch/archive/2007/05/05/handling-multiple-errors-in-ssis.aspx

Now, I never had any connection issues till...

Lynn Pettis (3/23/2009)

---

Here is some test code for you to start with and it does it all in T-SQL, not SSIS:

-- Create initial test table that will be the source...

Lynn. Your code worked fine. I was a bit confused with few columns as the table is huge.

Anyways, I have figured out the reason why it did not work. It...

No. This does not work. It gives me multiple records for a single ID.

I am getting

A1

A1

A1

A2

A2

A2

and one more thing is that I have some two datetime columns also in this...

I have it like this;

ID X Y Z

A1...

I figured out one more question.

What if I have similar ID's for two rows.

For some instances, I have same ID's.

Two rows having one ID. I wish to group by such...

Excellent. I tried it and its working fine. I tried with just two columns for now.

I will verify the data minutely and then go to the next colums also.

Thank you...

Hi,

Thank you for your reply.

But practically it will not be possible for me to add so many insert statements as I have more than 40,000 rows in this table.

Is...

More questions (detailed)

http://www.dotnetspider.com/forum/158771-Sql-Server-Integration-services-Interview-questions.aspx

I am getting this error:

[Pivot [43]] Error: The pivot key value "23:45:00" is not valid.

The reason for this error is that the pivot key value is a datetime field.

Does...

Thank you James. I am just trying to use the Pivot Transformation and achieve the results, but I have a datetime datatype and an integer datatype, which is giving me...

Thank you for all your replies.

I know this was a silly question, but I am still learning, so........

Thanks once again.

There columns Message, Date, JobStatus are not in table...

Try using the Data Conversion transformation for changing the data types.

I do not get a clear understanding about your problem from what you have posted.

But what I can tell you is: In order to create a variable, create a new...