Nils,

No, it is not on a virtual server.

Gail,

This is a production server; the scheduled reboot is this upcoming Sunday. Since this db isn't actively used, I think the plan...

I just double checked the application and...

Is this just the "wordiness" of SSIS? That is, when an error occurs you see multiple error messages in the process tab. These are what is getting logged.

Would...

Smash125 (9/21/2012)

---

Its been while have not given any interview SSIS.Just preparing my future course of action

One common questions that comes to my mind is

Explain SSIS architecture? My answer may...

sumit.joshij (9/24/2012)

---

Please check on http://msbi2012.blogspot.in/2012/09/expression.html%5B/quote%5D

Or to make it easier for folks :-):

http://msbi2012.blogspot.in/2012/09/expression.html

Rob

ramyours2003 (9/25/2012)

---

Recently we upgraded SQL 2005 to SQL 2008 R2 , while executing the package we are getting the below error

Microsoft (R) SQL Server Execute Package Utility Version...

The SQL logs just have [font="Courier New"]Error. 9001 Severity: 21. State: 1.[/font] - which I think is related to the bad log. And [font="Courier New"]The log for database...

Looking in Event Viewer on the server under Administrative Events, I see "The log for database 'DatabaseName' is not available. ...

robert.gerald.taylor (9/24/2012)

---

I've added an image to a tablix's textbox. I set the image's visibility based upon a column in my dataset. When the image is not visible, the...

Would your report work if it ran at 12:01am? What does the report's query look like? It's hard to speculate why this might not work without more info.

Rob

dwain.c (9/19/2012)

---

There's a (usually) faster way:

SELECT col

FROM @t

CROSS APPLY (

VALUES (col1), (col2), (col3), (col4)) a(col)

This article describes the CROSS APPLY VALUES approach to UNPIVOT: http://www.sqlservercentral.com/Authors/Articles/Dwain_Camps/1444841/...

Please don't post your question in multiple forums; it just fragments the responses.

Thanks

Yes, you want to create a variable and the set the flat file connection managers connection string property expression to use the variable that you created for the file name.

Take...

Couldn't you just unpivot your data? Something like:

SELECT DISTINCT SpecificCols

FROM

(SELECT col1, col2, col3, col4

FROM @t) t

UNPIVOT

(SpecificCols FOR AllCols IN...

$ammy (9/16/2012)

---

Hi,

I have created a SP which is used for Backup/Restore. Now the problem is I need to create a table which is used for collecting the log information,...