I tend to view one-time differently. A lot depends on the type of image data. Is it actually graphics, if so what file format? If it is...

da-zero (4/7/2010)

---

Elliott W (4/7/2010)

---

I'm a little fuzzy why we are making this so tricky..

Why don't you just use parameter mapping in the Exec SQL Task

UPDATE dbo.TableName

SET Field1 = ?, Field2...

Did you realize that the connections variable will NEVER contain anything. You define it but never populate it. When you define it, it is not defined as new....

You could use a script task or an EXEC SQL task to manipulate a variable and then using expressions assign it to the file pattern. Off the top of...

Which statement does it die on? The ForEach, the Name, or the ConnectionString.

CEWII

I'm a little fuzzy why we are making this so tricky..

Why don't you just use parameter mapping in the Exec SQL Task

UPDATE dbo.TableName

SET Field1 = ?, Field2 = ?, Field3...

I am having trouble understanding what exactly your question is. Could you explain what your problem is and not necesarrily your proposed solution.

CEWII

I am unsure why you want to create this package dynamically, but that doesn't really change anything in my mind.

So, 3M records and about 60GB of data. Over LAN...

How long does it take to run? What would you consider fast? How much data? The statement 3M rows doesn't tell me much..

CEWII

Not at all. It is possible to import all the required DLLs but it is really messy and I personally wouldn't.

CEWII

Are both sides SQL Server? Is the destination configured as fast-load? Also, on the source are you chossing the tablename from the list or are you using a...

I had looked at this exact question about 18 months ago and didn't find a really good solution. What I did was write a SQLCLR module that instantiated a...

My first question is whether storing image data in the database is the right path. The other is how you are doing the import. Where is the data...

I'd start with those links. If you have additional questions please ask.

CEWII

Is this a oneshot deal or something you will need to do over and over?

CEWII