Is that your expression?

That was Sheckster.

erngreen (9/13/2010)

---

This is a pure text file. I know that the tilda can be defined in the flat file connection. I have gone around and around on this issue for...

You never responded to my 'what if?' question regarding what would happen if a record had a city but not an age. Assuming that the answer is that there would...

sabarichandru (9/13/2010)

---

Hi,

Did u found any solution for the requirement .me also facing the same probs i found the solution also to resolve using Derived Column.

but another problem is that suppose...

sql.abhishek (9/7/2010)

---

Hi

Yes go to OLEDB Destination tab and put Data access mode = Table or view – fast load then u will have ur options like Rows per batch...

I'd do it using a script task - no outside EXE needed. How big is the file likely to be, roughly? There is, of course, a performance overhead doing it...

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...