August 19, 2010 at 5:18 am
Hi Everyone,
if the excelsheet path is changed then how can we execute a package. It is giving an error when the path of the excelsheet is changed or name of the excelsheet is changed.
Anyone please tell me how to go about solving this error
August 19, 2010 at 5:35 am
Of course SSIS will have problems if it's looking where it's been told and there's nothing there.
The simplest option (in terms of coding, that is) is that you change your process and make sure the spreadsheet (which I'm assuming is being imported) is always in the same place with the same name at the point where the package is executed.
The second simplest option is to make sure that the spreadsheet is always in the same folder (or a sub-folder of it) and to use a FOREACH container to process all Excel files in that folder tree (and then move them to an archive after processing). This way you can process dynamic file names, but it takes a bit more setting up.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 19, 2010 at 5:41 am
Hi,
what if the excel file is stored in a different location on the machine ? this is our requirement currently.
If you can provide me the steps I would be grateful to you
August 19, 2010 at 6:03 am
Maybe you should read about configuration files - they might give you the flexibility that you need.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 19, 2010 at 6:09 am
And don't forget variables and expressions!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 19, 2010 at 7:00 am
Hi,
Please provide me the steps on how to execute the package even if the excelsheet is stored at a different location from the package. when the package is executed, it gives an error if the excelsheet is stored in a different location from the package.
How do i tackle this problem ?
Please provide me the complete solution.
Thanks and Regards
August 19, 2010 at 7:20 am
river22_34 (8/19/2010)
Please provide me the complete solution.
Sorry if this sounds rude:
if you want the complete solution, hire a consultant.
Phil and I have given you enough hints so that you can start on your own. Google the keywords that we provided and you should find more then plenty information on how to tackle the problem. Even on this site alone you can find the answers easily.
ps: if you're interested in hiring a consultant, I can give you my hourly rates...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 19, 2010 at 7:29 am
da-zero (8/19/2010)
river22_34 (8/19/2010)
Please provide me the complete solution.Sorry if this sounds rude:
if you want the complete solution, hire a consultant.
Phil and I have given you enough hints so that you can start on your own. Google the keywords that we provided and you should find more then plenty information on how to tackle the problem. Even on this site alone you can find the answers easily.
ps: if you're interested in hiring a consultant, I can give you my hourly rates...
Not half as rude as what I would have written ... which is why I didn't. Bet I'm cheaper than you too:-P
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply