Search results for query: *

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...

(I would have posted this yesterday, but it seems that my account had been flagged) 2187 is a hotfix for the latest service pack (SP4) for SQL Server 2000. I got the same results from trying to setup a connection in the ODBC manager in Admin Tools. The connection is opened and closed when...

Windows 2000 Advanced Server (latest service pack) SQL Server 2000 Enterprise Edition (8.00.2187) 1. Server can see other machines in network through Windows Explorer 2. Server can connect to other machines in network through ODBC 3. Other machine can't connect to my server through ODBC 4...

Before I start poking around in the system tables, I figured that I would ask around on some forums first. What I want to do it two things: 1. Show on a graph how long each one of my nightly jobs runs, scheduled through SQL Agent. Also I want to show on this graph where my jobs overlap and...

I found out from someone else that you can only use the Set command for setting object variables, not for assigning values. I guess I do too much T-SQL instead of VB Script. Oh well. Live and learn. Thanks again for the help.

Now it works! Why???? Thanks, but it makes no sense why that would fix it. I have three other lines in that object that use the Set command. All of the code snipets I have found on the web use the Set command to put the date into the variable. I appreciate the help, but how would I have...