Hello!
I need to load data from CSV file to update a table. I understand that I could do it with a temp table and then run an update query from it. The problem is when I try to use a global temp table, I don't seem to be able to get Destination and Transformation tabs to work. The program doesn't find that table even when I try to create it on the server prior to going through the tabs.
I cannot create a regular table for these purposes and then drop it because my user doesn't have these permissions on the server.
How should I approach this problem?
Any help would be highly appreciated.
Thank you!
Kate
I need to load data from CSV file to update a table. I understand that I could do it with a temp table and then run an update query from it. The problem is when I try to use a global temp table, I don't seem to be able to get Destination and Transformation tabs to work. The program doesn't find that table even when I try to create it on the server prior to going through the tabs.
I cannot create a regular table for these purposes and then drop it because my user doesn't have these permissions on the server.
How should I approach this problem?
Any help would be highly appreciated.
Thank you!
Kate