1. Depending on the size of the data SQL could have required more space to be allocated. Auto Grow will kick in. Many time guys leave this default and that...

If your version of SQL supports column-store I would consider that as an option. Due to the repetition of data it would condense the volume of data you are storing....

Hi

In another blog post by Gail Shaw (a Trio Of Table Variable[/url]) I read that table variables are actually created in tempDB. You mention that SQL is less likely to...

Hey guys

My pain is not the update but rather that SQL is throttleing the IO. The scenario discribed above is only one of many. The server in general does not...

What SQL version are you running at the moment?

If it is SQL 2000 you would have to create seperate cubes and then a virtual cube above that.

SQL 2005 made it...

Hi

I do mine on the dailiy loads of the DW. My updates are coded within procs that check unique fields and insert those if they do not exist in the...

Hi All

An update. This update makes even less sence than previously thought.

The job failed again on the same step on the weekend. I added a retry to the job to...

Hi All

I tried to isolate the error by scheduling the package in a job on its own. This job runns every 10 minutes it has been going for 2 days...

Hi Markus

I assumed the same and did double check the datasource connections and redeployed the package. But with no success. I would also assume that if the datasource was incorrect...

Hi Michael

I find it odd that you can not see the excel connection type.

If I may elaborate on the way I did the excel connections. When I worked on SQL2000...

I am not to fimiliar with the proxy on SQL2005.

The dev I did I would connect to every file over the network in teh SSIS packages. This eliminated any issues...

Check the account that SSIS and SQL server agent starts with in "services".

Have you opened the SSIS package in teh Dev studio on the server and executed it from there....

Have you tried to run a "execute SQL task" against the excel connection. I use this to create the excel sheets inside the file and mod the datatypes where neccesarry.

The...

Hi

It could be a possible security issue. Have a look and see if your SQL server agent has access to the location of the file. It is a good idea...