CSV files are, by nature, not fixed length. Do you mean CSV files which have varying numbers of records on each line?

Phil

Jack's idea is a good one and can, of course, be accomplished in a single package using an initial script task to check the number of columns with a conditional...

Sounds like the SQL Agent service may be running with credentials which do not allow it to access the file. Is it on a network folder somewhere?

No - this error was driving me so mental with irritation that I had to give up before I snapped!

I now use traditional copy/paste methods to get the job done...

Create a Boolean variable IsWeds.

Create a script task containing some code like this.

Public Sub Main()

Try

Dts.Variables("IsWeds").Value = False

...

Explicit selection of only those columns which are required is surely the way to go here? Select * from xxx will often throw things out when the underlying xxx schema...

A reinstall of VS2005 and .NET Framework 2 has not fixed it. Bizarre.

Steve, don't want to be picky, but as it's the title of your article ... I think the word you're looking for is 'savvy' 🙂

PP

Don't remove the primary key unless you really really know what you are doing! The PK is there to enforce uniqueness between the records in the table - if you...

It looks from your post as if new tables are created every day - possibly with identical formats, and presumably storing data applicable to that day?

It's probably a major change...

OK, will try your (more helpful) syntax.

I was on the server (via RDP) and I was logged in as the SQL Agent service user when I got the error, so...

What's the query doing? Any cross-server stuff? Could it be a security issue (is your task running as a local user)?

If there is no primary key in either table, how can you determine whether two records are "the same". Do you have to compare all of the columns one by...

Where do you want to use it?

It's not available in Access SQL (AFAIK), but it is available in VBA. Or if you use a passthru query to a SQL Server...

You need to qualify your names further when accessing other servers.

Try using servername.DB1.dbo.Table1