February 8, 2012 at 11:53 am
I am trying to create a dynamic excel destination using the answer provided here:
I am following the same exact steps..
my SQL task is creating a file and a sheet/table inside the file properly, but when creating the Excel destination..when I click on the NEW table/View button..I am gettting 'Unspecified Error' 2-3 times..if I click retry, nothing happens..If I click Cancel 2-3 times, then it goes through, asks for the new table..here after giving the new table script, again I get 'Unspecified Error' 2-3 times. Again same, if I click retry, nothing happens..If I click Cancel 2-3 times, then it goes through and tells me that "The table name could not be retrieved from the script provided. Select a table or view from the drop-down list box". I am using the following script to create the table
CREATE TABLE `Master_Table_Ascender_DATA`(
`PATIENT_ID` INT,
`VALUE` INT,
`LAST_NAME` NVARCHAR(50),
`FIRST_NAME` NVARCHAR(50),
`DOB` DATETIME,
`MRN` INT,
`GROUP_NAME` NVARCHAR(50)
)
When I click on the drop down box and it gives me a message 'Please select the new Excel sheet from the Dropdown list box.Any white space in the excel sheet name may have been replaced by "_" '. When I click OK and hit the drop down box, again says 'Unspecified Error'. Again same, if I click retry, nothing happens..If I click Cancel 2-3 times, then it goes through and gives me a message 'No table or views could be loaded'
There is absolutely no other error message I am getting, nothing descriptive about it. I am dumbfounded here..please help me guys :'(
Update..
Instead of New table/View, if I use SQL Command in the Excel destination then it is giving me an error:
SSI Error code DTS_E_OLEDBERROR. An OLEDB error has occured. Error code 0x80004005. An OLEDB record is available. Source: "Microsoft JET database engine". Hresult 0x80004005. Description : 'Unspecified Error' 🙁
Here is a link to the image of the error:
http://imageupload.org/getlinks.php?s=c76f167ae3c602d41bc77a5a51ccc594
Forgot to mention:
The destination is deleted using a file system task..then a SQL task creates the excel file and table/sheet inside it..and then data flow
task is used to dump data in it..first two actions are working but having problem with the last one
February 9, 2012 at 12:34 am
Did you set the Run64BitRuntime property of the project to false?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply