D smith,

questions:

If the values coming in from the flat file do not contain blanks at all, can I bypass the NULL reference? Also in Derived Column what do you...

Assuming that your database that contains the table is set to 90 Compatibility (SQL 2005)

1. This is an assumption that you need to create the table and that the table...

I think with an upgrade it takes into affect the license option you had chosen for SQL 2000. But here is the Microsoft web link that provides in great...

Using FORMATFILE as per BOL you must meet one of these criterias...

The data file contains greater or fewer columns than the table or view.

The columns are in a different order.

The...

Can you provide syntax that includes the BULK INSERT?

Cannot see your attachment.

Please open SQL Books online and in the search enter CREATE ASSEMBLY

Read up on the syntax when using this command, this should point you in the right...

g_harrow,

Informix DB is made by IBM and is not a MS SQL Server product.

I found this link this could help you

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.dba.doc/dba.htm

Ok so place the error within the batch file....thanks

That's just too cool and I can't believe that after all these years Microsoft and other large companies can't just build something cool. Not neat, not solving a problem, but...

The problem was the destination table.

The flat source file for bank_acct_nbr was char(17) and after digging around the net, SSIS doesn't allow a char to char from outside source to...

Let me see if I understand this:

"Access DB (external/ remote data source) --> SQL DB

My system is such that I have to constantly import work orders from Access db into...

If I am understanding you, you want to run this script for each database on your server.

You need to use the undocumented stored procedure from Microsoft called 'sp_MSforeachdb'

What you want...

Thanks Jack,

Did the data control steps after flat file then to export steps look good

jack one more question.

if I have my Flat file as the source and OLE DB as destination, I want to clean the data in the DB table but when I...

Thanks jack I will remove the Bulk Insert Task from Control flow tab and go straight to data flow...