Frank Bazan (8/14/2009)

---

You can also use the OleDB GetSchema() method. I can't remember the exact syntax, but a search of msdn should help.

This allows you to query the excel catalog...

It will take a couple...

touchmeknot123 (8/14/2009)

---

Thanks Phil.

I am trying it out your way.

I am having trouble since the dll - 'Microsoft.Office.Interop.Excel' is missing.

I have installed the dll but I do not know how to...

You may...

Can you include more details like error messages you are getting, etc?

ns.sharath (8/13/2009)

---

I have a table with 300,000 rows where row by row update has to be performed. Use of an OLEDB command in Data flow task is a real pain...

sumiga_11 (8/13/2009)

---

Hi friends,

In my SSIS package an update statement and an Insert statement is running parallel on two different tabels in the same database. even if both the statements are...

touchmeknot123 (8/11/2009)

---

CozyRoc,

another quick question regarding the same.

I could do it because the woskheet names were extracted from filenames.

How to solve the same issue where the filenames and worksheets aren't related...

Greg,

The for each loop container is not the problem. The problem is caused by the data flow -> xml source -> xsd validation etc process. I'm thinking about this process:

1....

touchmeknot123 (8/11/2009)

---

hi all,

I have 4 excel files which are to be loaded in a table.

The data flow task when run 4 times to load the excel sheets, works fine.

But when...

danodan (8/11/2009)

---

I want to run SSIS package from another server from command prompt:

dtexec /DTS "\MSDB\Package_transfer" /SERVER sqlserver /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V

I got following answer:

Microsoft (R) SQL...

John,

I think this conversation is going nowhere. Anyone who follows this will agree I gave my best. As I said earlier, if you don't see a point of using third...

Gkhadka,

Thank you for the meaningful post and kind words.

I'm sure you realize, when you talk about "little extra efforts", this translates directly into time and money. As people say there...

John Rowan (8/10/2009)

---

CozyRoc (8/10/2009)

---

John,

1. I'm talking about this statement: "Dynamically building out the BCP command"

This is requirement to be a programmer.

2. I agree that depending on one component, could cause...

John,

1. I'm talking about this statement: "Dynamically building out the BCP command"

This is requirement to be a programmer.

2. I agree that depending on one component, could cause all your dependent...