hi all i created a simple package of extracting data from an Oracle db and loading into a table on the sql server. This i did in BIDS. Now when i open the integration services in the Management studio and under STORED PACKAGES>> MSDB i created a folder byname "SSIS_CPP" and now i right clicked the folder to import the package, here is where i'm not able to fill in the details PACKAGE LOCATION (What should ic hoose) - i logged onto a remote server (production) so should i choose "SQL SERVER" ? PACKAGE PATH: What should i enter here? Please need help. Thanks SV

Tutorial here: http://www.mssqltips.com/sqlservertutorial/220/scheduling-ssis-packages-with-sql-server-agent/ But yes - choose SQL ServerChuck

Your package is probably a file thus use the File System option, make sure you can bring the package across. Also, your destination is MSDB therefore use RelyonServerStorage for the protection level. Arthur My Blog

Thanks Oldjeep, but thats not what i was looking for, i created a new job in BIDS. When i open SSIS using SSMS there are list of folders under MSDB and i created a new folder and i wanted to IMPORT the newsly created job in BIDS into this new folder. ThanksSV

Thanks Oldjeep, but thats not what i was looking for, i created a new job in BIDS. When i open SSIS using SSMS there are list of folders under MSDB and i created a new folder and i wanted to IMPORT the newsly created job in BIDS into this new folder. Thanks SV So right click and import it. I'm not understanding your problem? You don't know where the dtsx file that you created is?Chuck

Hi saivenkat77, Do you mean is that you want to import the Job to the folder created in MSDB? Please feel free to correct me if my understanding is wrong. The MSDB folder is used to save SSIS package, I am afraid we cannot import the Job to the MSDB, if you are going to save the package to the MSDB, please take Chuck's suggestion. For more information about Package Management, please see: http://msdn.microsoft.com/en-us/library/ms137916.aspx Thanks, Eileen

SaiVenkat77, I guess what you are trying to do is deploy your package/job created in BDS to SQL server instead of File system. So when yo deploy your package please choose SQL server, Select the server Name and the folder (Within SQL Server) where you want to deploy the package.Manishankar Rajagopal | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker