In that case I would suggest separating the task into separate jobs.

Firstly,

Save all the excel tabs as separate text files

Secondly,

Import each text file into a set of staging tables using dts

Thirdly,

Create...

Yep.

LIKE '%[0-9]%'

Although I am very anti xml, I thank that this may help you out in this regards. I found this link a while back and it's very good if you...

Another way to accomplish is to use a dynamic properites task pointing the source table name to a value in an ini file. You only need to change the value...

As long as your data is not large or complex openrowset will work for you. You can also write the query so that both excel spreadsheets are queried and your...

I have built queries before around the sys tables, so i will probably go that way if needed.

Thanks, Remi. Unfortunately, whi is it that the boss IS always right, especially when they ask for so much detail?

I have a text comparison tool that runs like a pig, but...

Unfortunately we have fact tables with in the region of 1000 columns. Just to be that extra bit picky, my boss wants to see a visual report of the differences...

It sounds to me that what you really want is a generic package where you can specify source and destination objects as paramters and then run.

To do this you...

There is a way around this using some package settings. See this article for a simple explanation of what to do. Works every time:

http://www.sqldts.com/default.aspx?254

After reading this post you got me thinking. I was near certain that the packages had no restrictions in them and there was no assocaited db role to execute. I...

It is always the account that executes the package.

IE If you schedule the package as a job it will be the account that the sql server agent runs as.

If you...

You can do it manually but you are better of using code. This function will work for you.

Just pass in the filename with .xls extension plus the tabs you want to save....

I jut realised I gave you a bit of a bum steer. I forgot that you need to save the speadsheet as a text file first. You cannot import excel...

There is no real difference between csv and excel. You just need to go into the task and make sure the columns are still mapping OK.

Bulk insert works with excel...