Search results for query: *

AngelWPBTampa : Great info but I need to pass the file name into a bulk insert statement. When I tried to exec the VARIABLE it appears to have tried to parse the string into a sql stmt. Can you point me in the right direction?

It appears that there is a limit of 30 transformations, is this true?

SQL2000 XP client The process I use works except for one DTS package. I am pumping the results of several views into flat files. For on view (70 columns defined) the wizard refuses to create the destination columns and I can not map the transformations, When I click on the define column...

I have a table that stores several pieces of data. What I would like to do is create a view that represents this data as a single 'row'. Other than the ugly multiple step process is there an elegant way to accomplish this thanks in advance pete

If the text file was created with crlf as the row termination marker the DTS package will look at the first record in the text file to determin the max length. Any record longer than that length gets truncated. I ran into this problem a week ago, it's the way the text file was created. I used...

Thanks Guys!! Reviewing my documentation revealed that I had strarted with an entity named CH_Desc that was later renamed. Triggers evidently don't get automatically updated in the tool. I found it and fixed it. Sometimes it takes a clean pair of eyes to see the trees. pete

Terry: The insert statement is: INSERT INTO DUR__DV2K.CLX.dbo.vendors (vendor_id) VALUES('MPS') CH_DESC is not a name in any of the DB tables. One piece of info - Same error after I dropped and recreated the table. I built the schema using ERWIN. I tried dropping anll FK and Key...

Working on a new DB design and am using SQL2000 running on a 2000 server. I have a table (1 row existing) that when I try to add another row I get an ODBC error that says only Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'CH_Desc'. Checked in sysobjects, nothing there...

DUH - I'll go stand in the corner. Sometimes I cna't belive how stupid I can be, Thanks Terry

Help!! I am at a loss, thought I new some of this but havent a clue as to what is wrong here. SELECT distinct values FROM LOGGING.DBO.FIRST_CALL this yeilds a count of 150432 but if I say SELECT values, count(values) as counted FROM LOGGING.DBO.FIRST_CALL group by values having...