Hi,

i need to create SSIS package where i need to create job which will import data from Excel file and insert into global temp table for next iteration.

And my excel is having around 800 columns.

Can anybody help me,how to achieve this ?

Thanks

Hardik

What's the problem you're struggling with?

Aside from the temp table, it's a very basic package to upload an excel file to SQL Server.

I dont want to import directly into sql server.

I want to first load into global temp table,So i can iterate through it and check for the duplication.And data is not going to single table as well.

that is the reason i need to first load into global temp table.

Thanks

OK. The global temp table is in SQL Server, so you're still loading to SQL Server.

What is the problem exactly?

I want to create SSIS package ,So that will pick the large Excel file and put it into some some global temp table.

After then i want to put that data into 4 to 5 different table.

could you please let  me know the ways ?

Thanks

Moving Data From Excel to SQL Server - 10 Steps to Follow

How to create and use Temp tables in SSIS

can you please provide some example which can actually read data from excel file and load it into global temp table.So i can perform validation to each record and load it into sql server.

Thanks

Hardik

You just have to read the two articles and put them together. Every bit of information you need is in those articles.