December 16, 2005 at 12:38 pm
What's the query I use to transfer excel file to SQL 2005 table.?
December 16, 2005 at 1:40 pm
I use the connection Manager. Create a connection to the excel document.
December 16, 2005 at 1:44 pm
is this automatic?
I want to write a query so that when ever I get excel file (its going to be same file with additional data) I can just run the query so that if copies to sql data table.
what will connection manager do?
December 16, 2005 at 2:02 pm
The connection manager is what connects to the file specified. XX.xls and the Server and DB needed. Then you would use a Data Flow Control. Once you double click on that it is like 2K Source and destination with a Data Conversion task in the middle.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply