Can you elaborate what do you mean by "drop data" ?

If you can use third-party solutions, check CozyRoc Data Flow Task Plus. It has ability to extract column information dynamically at runtime and load this data to another dynamic destination....

Rick Bailey-440858 (1/6/2010)

---

John, Thanks for the fast reply. I have not really looked into any third party tool or proprietary import/export tools yet and I have to admit I have...

Have you tried the commercial CozyRoc ODBC Destination ? If your ODBC driver supports the bulk-load interace, it will provide much better performance. If you are using DB2, you may...

Have you seen Data Defractor[/url]?

Check this sample. It supports multiple inputs.

elchuru (1/2/2010)

---

public void Main()

{

...

How do you expect to see the destination data? The data flow task has to execute and load the data from the source into the destination. I think the behavior...

Is there an error when you try to open the component?

What do you have specified as row delimiter in the flat file connection manager?

You may also check the...

Did you specify your server port? If there is no separate entry for this try specifying in the server name like this:

<server>:<port>

BaldingLoopMan (12/28/2009)

---

I have a ssis package that i'm building. There is a portion that loads an excel file w/ data from a select i wrote.

The issue is i can't...

Suresh Kumar-284278 (12/22/2009)

---

Hi All,

I am planning to create a re-usable asset for my team "to check the Deployment Utilities created for the package".

Some times my team members forget to check...

CoThong (12/22/2009)

---

There's no error but the package wasn't execute when the code runs, even after I have change the file name to escape the backslash.

What else can I do to...