InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:25:10 GMT20http://www.sqlservercentral.com/Forums/Topic1404554-148-1.aspxHi i am sorry, its solved, error with my file path.. thanks for pointing that outWed, 09 Jan 2013 00:42:57 GMT10e5xhttp://www.sqlservercentral.com/Forums/Topic1404554-148-1.aspx[quote][b]10e5x (1/9/2013)[/b][hr][quote][b]Koen Verbeeck (1/9/2013)[/b][hr]Where is the package stored?[/quote]Its stored in numerous folder due to requirement. May i know which should package should i identify? the one inside the project folder, with the file type of integration services package?[/quote]How can one package be stored in multiple folders?You are referencing the SSIS package store in your .bat file (since you use the /DTS switch for DTEXEC), which is a specific folder in your SQL Server installation directory.Wed, 09 Jan 2013 00:14:33 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1404554-148-1.aspx[quote][b]Koen Verbeeck (1/9/2013)[/b][hr]Where is the package stored?[/quote]Its stored in numerous folder due to requirement. May i know which should package should i identify? the one inside the project folder, with the file type of integration services package?Wed, 09 Jan 2013 00:08:17 GMT10e5xhttp://www.sqlservercentral.com/Forums/Topic1404554-148-1.aspxWhere is the package stored?Wed, 09 Jan 2013 00:02:07 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1404554-148-1.aspxHi all,I had a simple batch file to run my ssis package. But i keep getting this error which i seriously dont uds why. I cross checks the name of my project and dtsx file name numerous time... This is the error:[code="sql"]Microsoft (R) SQL Server Execute Package UtilityVersion 9.00.4035.00 for 32-bitCopyright (C) Microsoft Corp 1984-2005. All rights reserved.Started: 2:20:42 PMCould not load package "\File System\TA_Report\TA" because of error 0x80070002.Description: Unable to find the specified file.Source: MsDtsSrvrStarted: 2:20:42 PMFinished: 2:20:42 PMElapsed: 0.032 seconds[/code]This is my bat file:[code="sql"]@echo off&SETLOCALrem set project && package name, ssis server IPset ssis_project=TA_Reportset ssis_package=TAset ssis_server=localhostrem set command name and log pathset run_ssis_cmd=dtexecset run_log_dir=D:\EW\TARpt\Logsrem set parameterset para=%1if "%para%"=="" ( set para=Default)rem set up log file suffixFOR /f "tokens=1-4 delims=/-. " %%G IN ('date /t') DO (call :s_fixdate %%G %%H %%I %%J)call :s_date_endif "%dd%" == "02" call :archive_enddel %run_log_dir%\%ssis_package%_log.txtecho Continue processecho .echo start to run %ssis_project%\%ssis_package%...%run_ssis_cmd% /DTS "\File System\%ssis_project%\%ssis_package%" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V /SET "\Package.Variables[User::Exec_Dt].Properties[Value];%para%"> %run_log_dir%\%ssis_package%_%log_suffix%.log"C:\Program Files\7-Zip\7z.exe" a %run_log_dir%\%ssis_package%_%log_suffix%.log.zip %run_log_dir%\%ssis_package%_%log_suffix%.logdel %run_log_dir%\%ssis_package%_%log_suffix%.loggoto :eof:s_fixdateecho in s_fixdateif "%1:~0,1%" GTR "9" shiftFOR /f "skip=1 tokens=2-4 delims=(-)" %%G IN ('echo.^|date') DO ( set %%G=%1&set %%H=%2&set %%I=%3)goto :eof:archive_endecho in archive_endecho Deleting old log files...cd %run_log_dir%echo del %run_log_dir%\archive\%ssis_package%_*.zipdel %run_log_dir%\archive\%ssis_package%_*.zipecho Moving last month log file to archive...echo move %run_log_dir%\%ssis_package%_*.zip archivemove %run_log_dir%\%ssis_package%_*.zip archiveecho Finish moving archive logs...goto :eof:s_date_endecho in s_date_endset yy=20%yy%FOR /f "tokens=*" %%G IN ('time/t') DO set _time=%%GSET _time=%_time:~0,2%%_time:~3,2%set log_suffix=%yy:~-4%%mm%%dd%rem echo %log_suffix%goto :eofENDLOCAL[/code]Whats wrong? Someone please help me. I read the other similar post and that guy problem is spaces problem...I dk if mine is the same but i tried renaming my files... still the sameTue, 08 Jan 2013 23:29:15 GMT10e5x