What inspired me was family history. I began tracing my family genealogy back in the early 80's and soon had reams of paper filled with data. Knew I...

This may be an even quicker fix.

Set the column delimiter to the normal (default) comma.

Run the package.

Edit the flat file to replace all the commas to a single-space (" ")

Edit...

Gail makes an excellent point about test VS. production tables. I have a 14.5 million row table and revamping SPROC this way took 6 seconds VS. unclocked for my...

Gail makes an excellent point about test VS. production tables. I have a 14.5 million row table and revamping SPROC this way took 6 seconds VS. unclocked for my...

Hopefully Adam, or someone else can answer this one.

Everything works wonderfully on my local workstation with the compiled DLL style library.

The issue is when I copy the DLL for deployment...

😀 Thanks Robert! I've focused so much on the Report Builder and BIDS interface (where I'd already deleted the model), It'd completely slipped my mind that I could also...

I've run into orgs before that don't allow UDF or stored proc's becasue the code is not in a 'code safe' (ie: Visual SourceSafe) like all their Java code. ...

For those interested the errors I was getting related to the Collation sequence.

For char and varchar data types I had SQL_Latin1_General_CP1_CI_AS NULL, which I had copied from a...

I too had several issues with the recommendation.  But I'll only tackle one, the DTS migration.

Virtually the only piece of SQL 2005 migration that is causing us headaches is the DTS...

That has been checked already.  The connection to the database is using integrated security to the database where the ID is a dbo.  This same ID is the SQL Server...

Is this in a .BAT or .SCR file?