This is a bit of a guess but if you are creating the table in Excell it will be using the Jet driver, It might not understand varchar! Try

CREATE...

Hi Jose - tell us you blocked 1433

When I can't find the error it's usually because I'm looking in the wrong place.

Is 'GL_DISTRIBUTION' owned by other than dbo?

Does it copy any objects?

Is it a dependant object and...

Sorry if I was not clear - does the account that the SQL Agent runs under have permissions. Right mouse agent in EM -> properties -> general tab?

Hi - anything in the windows event log? If you can run it interactively you can double click on the error messsage for more info.

You can switch on package logging...

It's always the spec that gets us!

What about

UPDATE tblBlah

SET MyField = LEFT(LTRIM(MyField),3) + '.' + SUBSTRING(LTRIM(MyField),4,6)

I would run it as a select first to see if it gives you what you want.

Yes - you will need to define anything other than the actual columns and their data type.

If you have any constraints etc they will not be copied. It does copy Identity...

You could try EXEC master..xp_cmdshell '< some dos command>'

If you want to quickly make an empty table the same 'shape'' as an existing table you can do

SELECT TOP 0 tblMyTable.*

INTO tblMyNewTable

FROM tblMyTable

This will give you the right...

Possibly the upgrade removed some tables (or other objects). If the copy was set up before something was removed I guess it would fail. If the job is a 'Copy...

Your idea of active dates is pretty much what BiTemporal is about. Try this link http://www.cs.arizona.edu/people/rts

You could try putting a transformation from any field into Claimdata.LagCategory then choose activex script and put a fixed literal in it equal to the length of the longest value...

There is a nice solution here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=252203#bm252418

The post from Rick Lowry

Argh * 2

I just lost my post and you have a fairly horrid problem - some options that sring to mind are

1. If Buick is removed code it as...