November 8, 2010 at 8:27 am
I am using excel 2007 files dynamically from ole db source in ssis 2005.
I am using the following connection string :
"Data Source= " + @[User::FileName] + "; Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1;\""
It worked the first time in my old machine.
Now I am using a different machine and I cannot get this conection to work.
I get the following error
TITLE: Connection Manager
------------------------------
Test connection failed because of an error in initializing provider. Invalid URL
.
------------------------------
Please help.
November 8, 2010 at 10:27 am
Was your old machine 32-bit and new one 64-bit?
November 8, 2010 at 10:34 am
not sure about the old one but new one is 32 bit.
November 8, 2010 at 11:40 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply