run ssis in 64 bit environment

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

run ssis in 64 bit environment

Author

Topic

gaauspawcscwcj
Starting Member

29 Posts

Posted - 2009-10-27 : 03:14:00

how to run SSIS in 64 bit environment???
here is my bat calling ssis :

DTEXEC /FILE "D:\SSIS\my_ssis\my_ssis.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI
pause

gaauspawcscwcj

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-10-27 : 05:28:13

Use the location of your DTEXEC within the SQL Server (x86) directories (usually \90\DTS\BINN\DTEXEC) - to force the SQL Agent to call the 32-bit version of DTEXEC.EXE

If this is not what you require, please clarify.

gaauspawcscwcj
Starting Member

29 Posts

Posted - 2009-10-28 : 22:04:53

thanks YellowBug
are u mean ;

"<dirver>:\MSSQL(x86)\90\DTS\Binn\DTExec.exe" /FILE "my_ssis.dtsx" /MAXCONCURRENT "-1" /CHECKPOINTING OFF /REPORTING EWCDI

gaauspawcscwcj

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-10-29 : 06:22:48

Yes. That's the folder.

If it doesn't resolve your issue, please post the complete error message.

gaauspawcscwcj
Starting Member

29 Posts

Posted - 2009-11-06 : 04:12:37

thanks YellowBug
its work well

gaauspawcscwcj

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources