Hi guys,
(sorry to repost from another area - just this one seems to get more attention!)
I have an SSIS package that imports data, runs some SPs to create a report, then exports this data to excel, then emails the excel file off.
Problem I'm getting i think is to do with the fact i am creating and building the package locally - then promoting it to the Live SQL SVR.
What are the fundemental 'rules'/'pre-requsites' for building on one machine and deploying to another?
I think i have them all checked off...
- Same User account creates as runs (with windows auth for SQL)
- user account has access to all relevant areas of folder structure (shares) to read/write the import/export files.
- user account has access to SMTP to email the report.
Is there anything i am missing?
I have tried the different package encryption (withUSerKey and withPassword) neither seem to work!
If you could possibly provide a 'check list' or any kind of advice that would be awesome.
Cheers guys
(sorry to repost from another area - just this one seems to get more attention!)
I have an SSIS package that imports data, runs some SPs to create a report, then exports this data to excel, then emails the excel file off.
Problem I'm getting i think is to do with the fact i am creating and building the package locally - then promoting it to the Live SQL SVR.
What are the fundemental 'rules'/'pre-requsites' for building on one machine and deploying to another?
I think i have them all checked off...
- Same User account creates as runs (with windows auth for SQL)
- user account has access to all relevant areas of folder structure (shares) to read/write the import/export files.
- user account has access to SMTP to email the report.
Is there anything i am missing?
I have tried the different package encryption (withUSerKey and withPassword) neither seem to work!
If you could possibly provide a 'check list' or any kind of advice that would be awesome.
Cheers guys
