You can put a breakpoint on the Execute SQL Task. When you execute package, it will stop before executing the task. That way you can inspect the locals window and...

Does the configuration table have NVARCHAR columns?

CSV --> flat file connection manager and flat file source

Excel --> Excel connection manager and Excel source

You need to split the rows (for example with a conditional split) and use three different Excel destinations to write the data.

There's a site called Google, did you check it out?

Greg J (10/11/2012)

---

Picture will explain all. I can't figure out how to assign a User::Variable in my Data Flow custom source command.

This works in 2008R2, and it gives me...

Nice question, thanks!

Eazy peazy! 🙂

Does the name of the excel sheet change? I guess not, so you can just use a derived column component that adds a column with the name of the Excel...

You should keep a log table somewhere where you log a record at the beginning of the package stating that the package is already running.

Before this task, add another task...

Duplicate post. Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1370553-364-1.aspx

Are you using a For Each Loop?

ranganathanmca (10/8/2012)

---

Hi,

I want to Extract(Export) 4 tables from SQL SERVER 2008 R2 to a Flat File.

All the four tables are related to each other (through PK & FK relationships).

Tables are

1....

Yes, manually set it for each table 🙂

Or you can just create truncate table statements for each table and paste it into...

If you can do all the...