emily-1119612 (9/7/2010)

---

I am not very familiar with OPENROWSET BULK.

I also should have mentioned that not every record would have embedded quotes. The following would be more representative.

"A","Is this a ""valid""...

I can think of one way:

1) Write some code that analyses the Excel sheets and does the DDL stuff for you.

2) Write more code which builds your package, using the...

sql.abhishek (9/7/2010)

---

Hi All

I want to extract data from multiple Excel sheets and then create different tables for that data in the SQL server and load that data into the respective...

Alvin Ramard (9/7/2010)

---

Phil Parkin (9/7/2010)

---

Agreed. You do what you can...

Agreed. You do what you can with the tools available,...

da-zero (9/7/2010)

---

Phil Parkin (9/7/2010)

---

This all assumes that the invalid data can even get into your pipeline in the first place of course.

If you have appropriate datatypes already set up for...

This all assumes that the invalid data can even get into your pipeline in the first place of course.

If you have appropriate datatypes already set up for your pipeline data,...

I would suggest that using SSIS to prompt for user input is a bad idea and generally accepted as bad practice. There is a good likelihood of the job hanging...

Please explain - why are you using SSIS, when it seems that you are executing only T-SQL?

Alvin Ramard (8/31/2010)

---

If I understood correctly what you're doing, I think you'll have to pass the resultset to a ForEach Container which contains you backup task. Inside the forEach...

Good luck!

Got to love those German error messages 🙂

OK, I think you are on the right track though - you just need to know what format to pass in the list...

Can you expand on "it does not work" - post error messages please.

Also, you may think it's obvious, but it makes things easier for people reading if you explicitly state...

Or you could embed some code in an Excel spreadsheet and (maybe) use this blank worksheet as a template.

The SSIS process populates the spreadsheet template with data and when the...

Yeah I know that - but what's important is the name of the sheets in the specific Excel sheet that you are accessing in your package.