January 19, 2016 at 10:05 am
Hello,
I had a requirement to run some queries on a certain schedule. I used the import and export wizard to create a SSIS package. Then I was able to create a job and schedule it. Job done!
Now, there is a need to modify the query. However, I don't see where you can edit a package created with the wizard. I don't even see the package. The server does not have Integration services added. The only place I am seeing the package is when you create a job, you can click the button and see the pacakges under SSIS package.
I don't see them on the drive or in SSMS. Does anyone know where the packages are at and how to modify them once you create a package with the Import/Export Wizard?
Thanks.
Tony
Things will work out. Get back up, change some parameters and recode.
January 21, 2016 at 1:43 pm
You need to connect to Integration Services and look under MSDB. Also the wizard is fine, but everything is hardcoded in the packages (connection settings, userid, password (if applicable), etc...) You should have a VS Solution that uses parameters. It is easily maintainable and transportable that way.
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 21, 2016 at 2:36 pm
Thanks Mike.
I know if Integration services were installed. However, Integration services are not installed on this server. The import.and export wizard is there. The package was created with the wizard although integration services is not installed.
Thanks.
Tony
Things will work out. Get back up, change some parameters and recode.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply