Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HELP WITH A QUERY
- Thread starter kcrewjap
- Start date
jbenson001
Programmer
How about a DTS package that you can schedule?
BULK INSERT is a more straight forward pull of data. It doesn't handle datatype transformations well, so if you've got a datatype in your shared folder that SQL Server doesn't recognize, then you could import it wrong.
So, BULK INSERT or a DTS package could both work depending on what you want to do or how you want to deal with the data.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
So, BULK INSERT or a DTS package could both work depending on what you want to do or how you want to deal with the data.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
- Status
Similar threads
- Locked
- Question