Have you looked at the XML of the package? It might be as easy as creating and adding your own XML nodes to the file. If it looks doable you...

Why in the world would you ever want to even attempt that?

Regarding collations:

I have seen folks on this site posting problems related to storing data in two different languages in the same column.

Regarding file storage:

Here is a good whitepaper I have...

See if this gets you close:

http://www.sqlservercentral.com/Forums/Topic872499-146-1.aspx#bm872724

I would not use a trigger in this way. Avoid triggers where possible. Is it necessary here? Why not allow the bulk copy to complete and then call a stored...

The only thing a VIEW can contain is a SELECT statement. What you want is a stored procedure. Or, if you change your concrete tables to table variables you could...

http://blogs.msdn.com/b/sqlcat/archive/2008/01/25/foxpro-to-sql-server-migration-experience.aspx

As an aside, regarding you...

tfifield (6/24/2011)

---

Just to add my 2 cents to what Sean posted. You should think of column names as objects in the database. The Employee table shouldn't have a...

You're welcome 🙂

In the case of all Unicode data you can use a binary collation to prevent the overlap of the number 2 with its superscript counterpart.

--CREATE TABLE STATEMENT

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

A conversion is happening because you're asking to replace an NCHAR in a VARCHAR column.

--CREATE TABLE STATEMENT

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TwoTable]

(

...

Can you cite an article?

http://ssisextensions.codeplex.com/ is 2008 only.

Cozy Roc has a 2005 component but I just looked at it and it appears as if it support OpenPGP only, i.e. it does not support Idea....

I think I am the same page as you now, sorry, I missed your *I* inference in your OP.

The intertubes did not turn much up for me, as I suspect...

The optimization issue is what keeps me away from table variables. I had heard about the recompile option but it did not sway my view on things given the expense...