Viewing 7 posts - 1 through 7 (of 7 total)
one procedure is there for validating ,dumping and to split the data into multiple tables using OPENROWSET('Microsoft.Ace.OLEDB.12.0').
here validating means checks for sheet names, columns in sheet or correct or not.
when...
July 8, 2014 at 2:43 am
one procedure is there for validating ,dumping and to split the data into multiple tables using OPENROWSET('Microsoft.Ace.OLEDB.12.0').
here validating means checks for sheet names, columns in sheet or correct or not.
when...
July 8, 2014 at 2:39 am
one procedure is there for validating ,dumping and to split the data into multiple tables using OPENROWSET('Microsoft.Ace.OLEDB.12.0').
here validating means checks for sheet names, columns in sheet or correct or not.
when...
July 8, 2014 at 2:38 am
actually one procedure is there for validating(checking for sheet names and for columns in sheet) excel and import data by using OPENROWSET('Microsoft.Ace.OLEDB.12.0').
and it split the data into multiple...
July 8, 2014 at 2:33 am
this is the message i got in catch block...
July 8, 2014 at 1:46 am
Thanks for replay, i have one more doubt ...
Is there any limitation for file size through query not from SSIS package.
it gives error message as
"server is not responding to...
July 8, 2014 at 1:17 am
Viewing 7 posts - 1 through 7 (of 7 total)