Viewing 12 posts - 1 through 12 (of 12 total)
Not to beat a dead horse but I just have to ask this question: what's wrong with taking the inventory count below 0? Here's a scenario I see:
20 salesmen...
June 11, 2003 at 6:15 am
I ran into this problem on my last assignment. IMHO, this is one of the most dangerous issues with DTS, because DTS happily loads the table with what it...
October 1, 2002 at 8:39 am
My favorite's a freeware package over on SQLDTS.com called "DTS Backup 2000".
The only reference I could find to the error you got was
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q281642&">
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q281642&
It pertained to...
September 20, 2002 at 10:39 am
Code looks ok and ran ok on my machine. Not sure what could be going wrong.
Are there other steps b4/after this one that could be causing or...
September 20, 2002 at 8:52 am
Take a look at this kb article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281517
I had this problem a while back. Antares is right; by default, DTS searches 8 rows and makes a determination of the...
September 20, 2002 at 8:22 am
If at all possible I'd make productid an int (or numeric if appropriate), and add a varchar column to capture the string data.
If you combine int and string...
September 17, 2002 at 8:14 am
I don't know why copying the .dts file didn't work. It's always worked for me, though it's slow and cumbersome.
Look at http://www.sqldts.com/default.aspx?6,105,204,0,1 for some ideas on transferring dts packages...
September 12, 2002 at 7:08 am
Importing from Excel is always an adventure and rarely a pleasant one. First, I recommend you go to http://www.sqldts.com and search on "Excel" to see some of the...
September 10, 2002 at 10:18 am
Importing from spreadsheets is never an exact science. Go to http://www.sqldts.com and search on "Excel" to see some of the issues. But let's see what we have...
August 29, 2002 at 9:28 am
On my last assignment the db docs were in Excel and I got so tired correcting the mistakes I ended up putting the descriptions into extended properties. I wrote...
August 26, 2002 at 7:22 am
If your vb program is an activex dll, it's just a matter of registering the component and using it in an active script task.
If it's an actual app (an exe),...
August 19, 2002 at 9:46 am
Local DTS Packages are stored at the server level, not in individual databases, so that shouldn't be a problem. Is it possible that some packages were stored as files or...
August 8, 2002 at 7:43 am
Viewing 12 posts - 1 through 12 (of 12 total)