You mentioned views.

What exactly are you copying?

What specific error are you getting?

I don't know if this applies without knowing the error but try this link:

http://blogs.msdn.com/b/ramoji/archive/2008/10/16/how-to-open-dts-packages-in-sql-server-2008.aspx

Ah yes, create an OLE DB Source in the Connection Manager as well.

You will dynamically set the connection properties.

You may find this article useful.

http://www.simple-talk.com/sql/ssis/working-with-property-expressions-in-sql-server-integration-services/

How about a SQL Task inside a Foreach Loop Container?

Are you assigning the Connection String to a Variable?

If not try creating a variable of string type to hold the Connection String. @[User::ConnectionString]

Change the property EvaluateAsExpression of @[User:::ConnectionString] variable to...

Typically you get that error when you have a syntax issue.

Were you able to get the breakpoints to work and step through the code?

I believe that you need to install the Ingres Client on the SQL Server Machine.

Instructions on how to do this:

http://community.ingres.com/wiki/InstallIngresClient

One problem is that the example code that you are using appears to be an older version.

If you click back on the first instance you will see some errors.

You will...

Please post your DDL, Insert Statements as specified in the link below.

What is the purpose of this exercise? 😀

I just did it. All you have to do is click on the line(s) of code then click on debug.

What happens when you hover over oFile.Delete(true) in break mode?

I developed comments for HL7 to Admit Transfer and Discharge Patients as well as billing.

There are a number of different protocols ( I remember three primary).

You have to have a...

That...

I agree that sample data would be useful.

That would help determine if the current design needs tweaked or not.