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
Post a Comment