"GO" is a batch spearator handled by the client. It is the equivalant of highlighting everything before the GO, executing the query, and then highlighting everything after the GO...

For awhile, we have a combination of some things stored in AD and almost everything else stored in databases (primarily Oracle, actually). All of the data has pretty much...

I just tried. I was unsuccessful running the package. It deployed, but it errors. My SQL 2005 machine is running sp2 and CU 6.

The documentation suggests it...

You are probably better off simply dealing with it in the query you use to get your data.

[font="Courier New"]CREATE TABLE #tmpData (

HIST_ID INT NOT NULL IDENTITY(1,1)

, PROD_ID CHAR(1) NOT NULL

,...

Thanks Jeff.

Apparently working in corporate IT for a decade has really honed my skills in the "Random Crap Generator" area.

That is the behavior you should get. When you are inserting or updating a record, you should be unable to select the same record. In SQL Server, you...

If you don't understand even what the job is, why are you interviewing for the position? You should call them and ask what they are talking about. If...

For the other piece, I again would not try to do this prompting within the package. Since your plan is to run the package with multiple data sources, I...

This is really outside what is going to be reliable in SSIS.

It is an ETL product, not a workflow management product. Creating a package that waits for user interaction...

Unless the data is actually in a gif or a jpeg, you should not have to screen scrape a web page to get the text. HTML is by definition...

Please post your query.

Other than the default roles, you are going to have to explicitly do the grant when you create an object. You could give the users db_datareader / db_datawriter and...

As far as service broker.

Assuming you have a window at night to allow you to do a complete ETL to your reporting database, that would be my base process.

For everything...

rbarryyoung - Yeah, 36.

Thanks for pointing out the fact that I forgot about the zero.

Sorry, I was mid-laugh thinking about how many combinations there would really be.

Well, if you used just letters and numbers - say all lowercase you have 35 characters.

Enter 35^10 in calculator and see what you get...