On a 64bit machine

Apr 27, 2011 at 2:27 PM

On a 64bit machine the correct installation path is
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Tasks
instead of
C:\Program Files\Microsoft SQL Server\100\DTS\Tasks

so this .cmd will work:

net stop "SQL Server Integration Services 10.0"
gacutil.exe /u "ICSharpCode.SharpZipLib"
gacutil.exe /u TaskUnZip
copy "ICSharpCode.SharpZipLib.dll" "%ProgramFiles(x86)%\Microsoft SQL Server\100\DTS\Tasks\" /Y
copy "TaskUnZip.*" "%ProgramFiles(x86)%\Microsoft SQL Server\100\DTS\Tasks\" /Y
gacutil.exe /i "%ProgramFiles(x86)%\Microsoft SQL Server\100\DTS\Tasks\ICSharpCode.SharpZipLib.dll"
gacutil.exe /i "%ProgramFiles(x86)%\Microsoft SQL Server\100\DTS\Tasks\TaskUnZip.dll"
net start "SQL Server Integration Services 10.0"
pause

 

Have a nice day!

Jul 6, 2011 at 11:10 PM

Agreed. I was having the same problem and came up with the same solution. I suggest creating a .CMD file just for x64 machines with Visual Studio x86 installations.

Btw, thanks to the author for this nice tool for SSIS! God job!

Coordinator
Dec 11, 2011 at 2:55 PM

Tnx! 

i upgrade version and insert your suggestions ;)

 

ciao

p