Recent content by Will192

Do you know what is inside the DTS package. Was the DTS package transferred from another system? It sounds like there is something inside the package that isn't installed properly. Something like it dumps to a different format and the program that handles that format isn't installed on...

A couple of questions: 1. Is there any indexes on the table being inserted into? 2. Is it possible to insert batches of 40k a shot? 3. What is the size of your tempdb? 4. What are your specs on your server? Live to Throw Throw to Live

I would just do a xp_cmdshell and rename the file to an xls extension. Live to Throw Throw to Live

Do you have Office installed on this machine? I have seen that message too many times to count. The main way that I made it disappear is to do a full install of office or just do a full install of each program that you are installing. (Install all of Excel options instead of just installing...

What are you doing in the DTS package? Is there any chance that you can convert the DTS package to just using T-SQL? What exactly is the DTS job doing that you can't do in T-SQL? I think I have another way around this, but let me know what your DTS job does. All of the other ways that I...

I was saying originator or anyone who has posted to the thread. If star abuse has never been a problem, then nothing needs to be changed. Live to Throw Throw to Live

So wouldn't the logical thing to do would be to only allow stars to be given out by the originator of the thread or by someone who has posted in the thread? Just a observation. I won't critique this site any further. It seems to be a good site and I don't come here often enough or have used...

I just noticed that I can go into a thread that someone else started and thank someone else for a thread that I didn't post in or start. What's to stop me from creating two accounts and going into all of my old posts and thank myself for everything I've ever posted?

monksanke & kaht - Bite me. You two obviously don't know what the heck you two are talking about. Don't post unless it is something constructive. You guys seem like trouble makers to me. (I work with kaht and monksnake, it's meant to be a joke) Yes, I understand what a signature at the...

The is my favorite conversation with a Win95 user: (I have actually had this same conversation many times, honest!) Me : You are running Windows 95, right? User : Right Me : Do you see the Start button in the lower left hand of your screen? User : (very quick response) No Me : Look at the LOWER...

SQLBill - Ok, I admit that I missed the whole give-a-star-link thing. This site's pages aren't setup very well for the infreguent poster like myself. When I just glance at this forum it seems to have a million little 5pt text links in multiple colors, in different fonts all over the place...

The connection is only using TCP/IP. The port sql server is using is the default.(I will double check though)

We do try to reconnect, 3 times, all failed. I don't think the problem is just ODBC. I found out that the nightly FTPs that we have coming in also failed. Everything coming in failed, everything going out was fine. In my opinion that means that someone is tweaking a firewall, router or...

I have finished going through my old posts and have given out 42 stars.

ptheriault - Nothing in the SQL Server log. I will look into the ODBC settings that you suggested. come one, you gotta agree with me that AlexCuse could have went about it a little more politely, instead of accusing me. By the way, I have been going through my old posts and already have...