Ouch...

CEWII

I think there is very little issue with this provided you don't use any SQL 2008 only functionality.

The places where you needto be conscious are SSIS, SSAS, and SSRS. ...

I've never got something like this to work. It is like SQL can't decide exactly what the structure of the output will be..

Now if you get that...

I don't think you can do this.. But you might try

SELECT FieldName = dbo.<functionname> (?)

OR

SELECT * FROM dbo.<functionname> (?)

I'm not sure either would work but that is how...

varchar(max) is more a synonym for TEXT, which is included for backward compatibility. I rarely build command strings up to 8000 characters, I usually use varchar(8000).. If you...

Why don't you change from varchar(max) to varchar(8000).. I think that'll do the trick..

CEWII

I'm assuming this is a 32-bit environment? I don't believe virtual memory needs to be more than 4GB. I think some others can more clearly tell you why,...

Template packages!!! Yay!! I have been working on one for all my BI stuff that includes all the underlying infrastructure.. I still have to go back to...

Can I ask a stupid question...

What is the problem you are trying to solve with the copy of data. It seems like a lot of effort to take this...

You can do this by getting the max date from your data and putting it into a variable, then use the variable in the SELECT statement at the source OLEDB...

ItalianOlgi (10/8/2009)

---

Owwwwww,so I am not only one who "exaggerated" my skills? You are working with someone like this right now side by side,so maybe I am not so bad? And...

I have to agree with GSquared here.. In some cases not knowing isn't so bad, but you had better have a plan to how you *will know* in the...

I would think as a practice you would try to save NO protected information in the package.

In the cases we did we had that data in config files, everything else...

Default instance or named instance? Did you specify the full name?

Really stupid question coming..

Is the service running locally? (sorry, had to ask).

What port does the errorlog show the server...

Good to hear you found it cus I swear that wasn't the way it was supposed to work..

CEWII