still1 Posted January 22, 2010 Share Posted January 22, 2010 Hi, I have been looking for an alternative to insert txt file to database for processing. Its SQL server2005. we are trying to eliminate xp command shell. I tried bulk insert but unfortunatelky it is not working in production environment. Any thoughts? Link to comment Share on other sites More sharing options...
0 Antaris Veteran Posted January 23, 2010 Veteran Share Posted January 23, 2010 You'd need to transform the data before pushing it to SQL. Do you have those facilities? Link to comment Share on other sites More sharing options...
0 BGM Posted January 24, 2010 Share Posted January 24, 2010 SQL Server Integration Services is your friend, use it to read the text file and insert into a suitable table :) Link to comment Share on other sites More sharing options...
Question
still1
Hi,
I have been looking for an alternative to insert txt file to database for processing.
Its SQL server2005. we are trying to eliminate xp command shell.
I tried bulk insert but unfortunatelky it is not working in production environment.
Any thoughts?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts