Allow multiple users to interact with your excel file

 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

SSIS - [Excel Source [11]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

 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

Excel - Make excel column uneditable

 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 :)

SSIS : Package execution completed.Click here to switch to design mode, or select stop debugging from debug menu

 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 

PowerApps - Add data from Dropdpwn to form

 Hi all,

To be able to submit data from a self created form in which drop down is present and submit to database use COLLECT function in PowerApps

Collect('[dbo].[POS_Target]',{POS_ID:Value(POSID.Text),Country_Name:Market.Text,POS_Name:POSName.Text,MONTH_NAME:Month.Selected.Value,Year_Detail:Value(Year.Selected.Value)})

A drop down would require Selected.Value and if it is a number then it requires cast and hence bound it by (Value)

PowerApps - "Add a DataSource" option is missing

 Hi All,

Here is a error which took me more than an hour to fix.

I wanted to add another table in PowerApps and I could not find "Add New Data Source Tab". To get the list of tables from which you can choose

Click on View, In search bar of Data tab type sql, click on your datasource name and to your right hand side, you would find the list of tables

Phew!!Wonder whether coding or finding is difficult ??

PowerApps - Insert a collection

Hi All,

Find below the formula to insert a collection in PowerApps. This can be used in places where data is limited

ClearCollect

(

CurrencyDetail,

{

AUD:"AUD",

CHF:"CHF",

CNY:"CNY",

EUR:"EUR",

GBP:"GBP",

HKD:"HKD",

IDR:"IDR",

INR:"INR",

JPY:"JPY",

}

)

Enjoy coding!!