I am not able to view the ssis packages?
I have created a new ssis packages.But it is not showing in file system option of Management Studio (Integration services).Thanks
April 12th, 2012 12:37pm
Hi, what are you trying to do? Trying to add the package to some job? SQL Server is in the same machine as your package?
David.
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2012 12:41pm
Have you deployed the SSIS package yet?Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar |
My Blog
April 12th, 2012 1:00pm
No this is first time.Thanks
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2012 1:02pm
Follow this link here
http://msdn.microsoft.com/en-us/library/ms140117.aspxPlease vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar |
My Blog
April 12th, 2012 1:03pm
Raunak I have created a new package inside BIDS and saved it also.
Still it is not visible.Thanks
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2012 1:05pm
Hi,
You have to deploy the package to SQL Server to be able to see the package in SSMS. Have you checked the URL shared above?Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar |
My Blog
April 12th, 2012 1:07pm
Thanks, But I am not getting below extensionfile as:
<project name>.SSISDeploymentManifestThanks
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2012 1:14pm
Follow this link. This is more comprehensive
http://msdn.microsoft.com/en-us/library/ms137592(v=sql.105).aspxPlease vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar |
My Blog
April 12th, 2012 1:21pm
Yes David,
I want to add a package in my job.
Package is used to run a batch file from a job.Thanks
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2012 1:25pm
You don't have to deploy it, you can add it as file system package:
SQL SERVER Running SSIS Package in Scheduled Job
But your package must be in the same machine as the SQL Server.
David.
April 12th, 2012 1:29pm
You don't have to deploy it, you can add it as file system package:
SQL SERVER Running SSIS Package in Scheduled Job
But your package must be in the same machine as the SQL Server.
David.
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2012 1:29pm