March 23, 2012 at 2:54 am
User is asking to provide the lastest SSIS packages used for 'DM Summary' and 'WMT_port_Package' jobs in Production database serve.
Can any one help me how to provide the latest ssis packages .
Thanks,
March 23, 2012 at 3:00 am
open up the jobs, look where the packages are stored (msdb or filesystem) then use SSMS connected to the SSIS server where they are stored to download the packages
March 23, 2012 at 3:35 am
Can you please tell me where to look in the jobs that packages are stored.
I have checked in the job and package source is "FILE SYSTEM"
I have connected the SSIS using SSMS and could not see any pacages name in the FILE system ,
Can any one please help me
March 23, 2012 at 4:57 am
If they are on the filesystem, there should be a filepath in the job that references the package.
The user is asking for the latest version. Are there versions stored somewhere else? (On a development server perhaps?)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 23, 2012 at 5:18 am
From JOb-properties-Steps- i could see the below path in the "command line "
/FILE " F:\MSSQL10.MSSQLSERVER\MSSQL\SSIS_WMT\WMT_ Data Import.dtsx " /X86 /CHECKPOINTING OFF /REPORTING E
Can you please clarify whether is this file i have to provide 'WMT_ Data Import.dtsx' to user.
and also
In Package --F:\MSSQL10.MSSQLSERVER\MSSQL\SSIS_WMT\WMT_.....dtsx
Can you please tell is this correct path which i am looking .....
March 23, 2012 at 6:06 am
The path you mention is correct. It's the path where the SSIS package is located that's being used by the job.
However, is this job in production? Then this package is already being used? Is this the last version?
That's only something you or someone else in your organization can know, not some random strangers on the Internet.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply