Forum Discussion

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago

Hi J_Tanna

 

What you would need to do, is to go into the Query Editor, and create a new connection to your SQL Server Table.

 

Then once that is created you would then go into the Advanced Editor and copy all the M Code.

 

Next you would then need to go to your Excel Source, and replace all the steps that refer to the Excel Source and then replace it with the copied code from the SQL Server table.

MAAbdullah_47's avatar
MAAbdullah_47
Icon for Helper V rankHelper V
5 years ago

Hi GilbertQ 

I need your help , I need more details about this step I have the same case for the posted question but you didn't show any details , could give some details on how to do this migration steps?