thanks - great question.

thanks for the question and thanks for the additional explanations...

Sean Lange (8/5/2011)

---

BenWard (8/5/2011)

---

Am I the only person who thinks those salaries are horrifically low?! If I was only paid 5000 units of currency per year (regardless of currency!) I...

Great question and some interesting info out of the references too.

So can I take it from all the chatter this morning that we will have no shortage of submissions for future QoTD? 😛

Thanks for the question. Totally got...

My fellow team members and I have been quite happy with the WROX SSIS books.

hmmm... I have experienced something similar in the past but that was related to the user not having a valid DEFAULT DATABASE set. I would expect that to...

Using Management Studio can you log in as user 'SSIS' and connect to the server you are reporting the issues on? If so, does the package run successfully on...

davidr (5/14/2009)

---

Hi - I am getting exactly the same error and it is driving me nuts trying to resolve - seems ssis does not like the fact that the database...

DOH! :w00t:

A wee bit vague... I guess ultimately it caught me out since i made assumptions as to the permissions for SQL Server access to the stated directory...

i've used this basic approach successfully, to loop through multiple flat files without knowing their names up front. with the loop and use of variables, i am able to...

In the server Event Log, was there anything abnormal going on during these times? I had an issue last year with GNE's that would hose up network connections to...

I ran into a similar problem on a workstation, not on a server. The issue was that when the workstation was rebuilt, the MSXML 6 Service Pack 2 was...

As yet, we have not migrated our ODBC source DTS packages...

You may have already tried this, but to determine if the ODBC source is really the bottleneck, you could try...

Maybe this should be the next QotD:

Is MDX TSQL?

😛