:rolleyes:

Yes, the time portions were very relevant for...

I must say, today's newsletter from SSC has a really interesting advertisement for an even more interesting book.

:rolleyes:

Very good question! More of these please.

I would use the SSIS option, but that's a personal choice. I try to avoid many calculations/custom queries in the DSV. This because they seem to be 'hidden' in your...

Very nice question, definately learned something.

And thanks to vk-kirov for pointing out an important remark. I hadn't even noticed it when I read the BOL page.

Maybe this thread can offer a solution:

http://www.velocityreviews.com/forums/t76336-re-how-do-i-fix-cannot-create-activex-component-problem.html

(I don't know anything about ActiveX, I'm just browsing the net here :-))

Nice question, although I believe I've seen similar around here (but hey, it can't hurt to refresh things from time to time).

Some reference links would have been nice for those...

Do you get the errors when you run the package in BIDS or when you run it on the server?

Are you sure the package is deployed correctly to the server?

I'm having a hard time to understand your example. Are those meant to be 4 lines, or 12 lines?

If 4, that won't work. CR/LF is a new line for the...

Here you go:

http://www.sqlis.com/sqlis/post/Sorting-MSDB-package-folders.aspx

Or you can just upgrade to 2008 or later, that will also do the trick.

ps: seriously, why is everything in your post in bold?

Maybe it has something to do with the problem described in this thread:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7fcbfc4b-2211-47b0-9e17-60266d5923b4

If not, then maybe you can try to check if the package really runs under the desired account...

Dan Guzman - Not the MVP (12/10/2010)

---

Yes, I did mean a staging table. And considering today's QOTD, I doubt the context would allow #tmp table creation in one flow,...

In the error log, is it specifically the disabled task that gives the error, or another task?

As HappyCat said: add IMEX=1 to your connection string. IMEX stands for intermixed data types. In other words, if Excel notices that a column contains more than one data type,...

Nice question, thanks.

(but it surprises me that apparently 78% -for the moment- know the exact error message!)