Read the text file in via a Flat File source and write it to a staging table with an IDENTITY-column.

Use an Execute SQL Task with a T-SQL script that loops...

Probably yes, but I have more experience setting up a while loop in T-SQL than configuring a for each loop with an ADO.NET enumerator, so I personally would choose for...

I think a better, flexible and generally more accepted solution is to enable logging on your package and write the logging data to a table. If you have to write...

This is a very, very, very common problem with SSIS and Excel. It shows up in hundreds of blog and forum posts.

Have you tried Google?

The issue is that Excel guesses...

I have absolutely no experience implementing RBAR, but this is how I would try to do it:

write the contents of the Excel file to a table (temp table or persistent...

washawgolla (4/22/2010)

---

I have one more question though;

I am importing around 60 tables to sql server from interbase; do I have to create 1 data flow task for each table (60...

Putting '0123 in Excel is the same as 0123. The ' serves as a text...

I have had issues before with string variables and SSIS thinking it was a number.

Most of the type these happen when I create the variable and change the type to...

Read the column in as text.

Use a derived column component to chop up the string into 2 substrings, one before and one after the hyphen that you want to remove...

Sure. There are lots of other client applications that can use cube data.

One of the most used is Excel. Even competitors like Cognos can use cube data from SSAS and...

Hopla, learned something new today 🙂

I'm curious, what settings give this...

Hmmm, not really a good question, as the answer depends on what system you use.

And no, knowing that it should work on 2008 is not an argument. In that case,...

Aside from the Excel filename, you should also provide the name of the sheet where the data is.

If this changes from file to file, you are in for a world...

This topic has been crossposted.

For answers, see this topic (or Wikipedia or Google) or this one:

http://www.sqlservercentral.com/Forums/Topic907428-147-1.aspx