Hi All,
To share the workbook, the below link was useful for me
https://www.youtube.com/watch?v=t8BfWUFsl8I
Note it is very important to perform the below step of putting a check mark "Use old shared workbook features and not the co-authoring experience" without this sharing option will not work
Well well,
I had promised my client that I would deliver an SSIS package in a day's time as I had estimated the task completion to be an hour. But alas..I got stuck with this error.
It took me whole day to resolve this error.
Resolution
Recreate the folders
Bingo..!Issue fixed
Cause -
SSIS seems to have had problems in connecting to files that existed in prior folders. So I deleted the folders, recreated and then placed my excel files in it to get it resolved
Hi All,
I have a requirement where I have to create an excel sheet with few columns as uneditable. I have used the below steps to resolve it
To make a column non-editable:
1. Select the whole worksheet, Right Click->Format Cells->Protection, uncheck the "Locked" check box.
2. Select the column you want to protect, right Click->Format Cells->Protection, select the "Locked" check box.
3. Review tab->Protect Sheet, select the "Protect worksheet and contents of locked cells" check box and protect the sheet using a password.
Enjoy working :)
Hi All,
After 4 or 5 long years when I got a task to work on SSIS, I was so exited. But when I ran the package I came across this error for first time
I had two "For Each Container". So parallel execution should have worked. But when the container is run individually the package gets completed.
Upon further research, I was able to understand that since both the containers were pointing to same excel file but of different sheet, this error happened. So I have kept two different packages for each of the container and Bingo!! Issue is fixed
