August 20, 2008 at 12:38 am
Hi,
I am tring to load excel sheets, this is containing First 3 columns are haveing the discription of the data, for this i checked in this forum i got 1 solution.(http://qa.sqlservercentral.com/Forums/Topic435110-5-1.aspx).
I tried same, the query is working in Manage ment studio, it's fine.
same i am trying as a Package.
I Took Excel source as a source, configard the conncetion manager,
In data access mode i selectd SQL COMMAND.
I am trying to parse that query. it is showing Syntax error in FROM clause.(plz find the attachments)
Can any body help on this.
URGENT.
thanks.
August 20, 2008 at 1:19 am
You are using SQL to read from excel. The Excel source reads directly from the file, not via SQL.
Either change your source to be oledb source and use your existing query or remove the OPENROWSET fro your query and keep using the excel source.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 20, 2008 at 2:17 am
Crispin, thanks yar it is working fine. i changed sourcetype into OLE DB.
August 20, 2008 at 2:21 am
I would rather do it the other way. Use a Excel connection.
Here's why:
You are invoking SSIS who runs a SLQ task who asks SQL to open the excel file who hands it back to SSIS.
Why not just ask SSIS to open the file? Cheaper on resources.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply