I am assuming this was your post on MSDN and it is now resolved:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/d00bb280-77bd-487c-8785-658beb08e296

Here is a tutorial on how you might be able to capture the number of affected rows into a variable, depending on how your SQL Statement in your Execute SQL...

My solution requires the use of a Tally Table (a.k.a. a Numbers Table). For this example my tally table is stored in the master database and is made accessible by...

I would not recommend using xp_cmdshell for this. I recommend keeping the option disabled on your instance if at all possible. Truthfully I would not do this work in T-SQL...

Which might be more common, someone asking to which physical object does...

If you have a complex XML file and SSIS detects 80 outputs then you'll have to process each of the 80 outputs in some form or manner if you want...

Please do not cross-post. It just fragments responses and wastes people's time.

Direct all replies here:

http://www.sqlservercentral.com/Forums/FindPost1406209.aspx

AD Groups as SQL Logins and Database Users work great unless you need the User to have a default schema. In SQL 2012 the loop has been closed, but this...

If you have a complex XML file and SSIS detects 80 outputs then you'll have to process each of the 80 outputs in some form or manner if you want...

Please do not cross-post. It just fragments replies and wastes people's time.

Direct all replies here: http://www.sqlservercentral.com/Forums/Topic1406350-148-1.aspx

From the error message the package appears to be failing on the OLE DB Source so I am wondering, is it even reaching the Data Conversion you said you added?...

That can be caused by two sessions executing the proc with different SET options, e.g. ARITHABORT. Each execution plan has within it the set of server options that are set....

Sean Lange (1/11/2013)

---

You do not have as much control over the datatypes when using a select into either, it will use the datatype from the source. That is not a...

Not a problem. I hadn't played with unpivoting data in a long time so I took it on as a learning challenge. It took me about a half hour to...

This is unpivoting multiple columns. See how these results look:

WITH TestQuestions(Id, Question, AnswerNumber, Answer, IsCorrect)

AS (

...