question

ChristopherJack-1763 avatar image
0 Votes"
ChristopherJack-1763 asked Monalv-msft edited

SSIS Works in development but fails when deployed

Hi,


I have made a basic SSIS package which reads and excel file, moves it to a folder copies it then renames it and deletes it.

I have two variables


It works fine in development however it is failing on the move step.

I am using connections rather than a variable for this part .. however the error message i am getting is

Could not find a part of the path

Help appreciated

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ChristopherJack-1763 avatar image
0 Votes"
ChristopherJack-1763 answered Monalv-msft edited

Issue was due to using a alias in the path name

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ChristopherJack-1763 ,

I am glad to hear that the issue has been resolved.

If you have a new issue about SSIS, welcome to this forum.

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 Votes 0 ·