how i opening comparison information source an ssis package deployed 64-bit server?


i have an ssis package exports information integrate comparison files send third party. run scheduled office 64-bit server i know i need set step cmdexec form 32-bit chronicle dtexec. nonetheless i don't seem means management right pass tie twine comparison files.



so distant i have this:



dtexec.exe /sql \packagename /server our2005sqlserver /connection 
letter_excel_file;\""provider=microsoft.jet.oledb.4.0";"data
source=""c:\temp\basefiles\letter.xls";"extended properties=
""excel 8.0;hdr=yes"" /maxconcurrent " -1 " /checkpointing off /reporting e


this gives me error: option "properties=excel 8.0;hdr=yes" valid.



i've attempted few variations selection outlines nonetheless have means right yet.



does anyone know repair this?



update:



thanks your assistance nonetheless i've solid csv files now, seem only work 64-bit version.



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?