Transfering data from multiple excel file to database

Question

1.00/5 (1 vote)

See more:

Hi all...
I have to transfer data from multiple excel files to database. I used foreach loop in ssis.
But I am getting error after using connection string also.
I also used provider for variable then also its giving error.
Can anybody help me...

Posted 29-May-13 1:35am

xyz from Bangalore

Add a Solution

Comments

ZurdoDev 29-May-13 7:42am

We really need more info. If you are stuck on the connection string clearly that is what you need to fix first. What is your connection string? What is the error?

xyz from Bangalore 29-May-13 7:56am

When I provided provider for connection string its giving error as "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” + @[User::FileName] +
“;Extended Properties=\”Excel 8.0;HDR=YES\”;”
0 is not recognized.The expression cannot be parsed because it contains invalid element

ZurdoDev 29-May-13 8:03am

Are you doing this in the Expressions section of the connection?

xyz from Bangalore 29-May-13 8:06am

Ya..

ZurdoDev 29-May-13 8:10am

What's the 0 from at the end?

xyz from Bangalore 29-May-13 8:14am

Its giving error for that provider expression, character number "0" is not recognized

ZurdoDev 29-May-13 8:24am

Are you sure your FileName variable is set right?

xyz from Bangalore 29-May-13 8:26am

ya. I have given package scope and value to path of file

ZurdoDev 29-May-13 8:43am

Maybe you need to hardcode the full connection string first and get that working, and then work on using a variable.

xyz from Bangalore 29-May-13 8:45am

Sorry,I didnt get that.I am new SSIS. Where I need to hardcode connection string?

ZurdoDev 29-May-13 8:46am

Instead of concatenating the variable into your connection string, just hard code it. Try to narrow down where it is going wrong.

xyz from Bangalore 29-May-13 8:50am

I tried that but it is giving same error.Its giving error for 0

ZurdoDev 29-May-13 8:58am

Then I would recommend searching google to see what the connection string for excel should look like. You need to get a working connection string first, then you can work your variable back into it.

xyz from Bangalore 29-May-13 9:00am

Ok,I wil try for that. Thank you...

ZurdoDev 29-May-13 9:04am

Maybe see this one, http://tsutha.blogspot.com/2007/07/building-dynamic-connection-string.html

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)