I'm on SQL 2008. I am trying the script and getting an error:

Msg 245, Level 16, State 1, Line 7

Conversion failed when converting the varchar value ';

EXEC (@sql);

' to...

ok, I'll check the settings.

Yes, someone downloaded or named the file wrong and so we got a different format that it tried to import.

Some good information:

http://www.simple-talk.com/sql/ssis/working-with-ssis-data-types/?utm_source=ssc&utm_medium=email-main&utm_content=ssisdatatypes-20120723&utm_campaign=SQL

ok thanks.

O stupid me, I just realized it's showing up on the Results tab, I was expecting to see it on the Messages tab! After I set results to text,...

I'm still having problems with this. Any hints?

Somehow I came across this http://www.sqlservercentral.com/Forums/Topic968770-391-1.aspx

I tried changing the directory, which was empty to either like d:\jobs or even c:\windows\temp and neither worked. c:\windows\temp actually seemed make other collection...

ok thanks. I see them under the Datacollection database now.

I thought I had seem them being accessed under the "System Data Collection Sets" themself.

Also, what does:

"NB:

@Fill_Factor, @PAD_Index will only be applied to index that are rebuilt (Fragmentation >= @ReBuildTheshold)

***There is a possible issue with database names containing GUID's***"

What's the possible issue? You...

I'm confused, somehow I have version:

Version 1.9

Removed option for all database in simple recovery model

Listed out all 80 (or earlier) compatibility databases

15 Aug 2011

Yet, this is a December version of...

This morning, the job actually did output completely to the file. That job was scripted from an SQL 2005 system. Maybe because I went into the step and...

I'm attaching a screenshot of what I have selected and filled in.

So, basically, I need to log to a table in addition to log to a file to get all...

Output to file does not work?

Can you clarify that current should be less than available?

See mine...

People are being asked to do more than one just job or have more than one skill. I admin Linux AND Windows related to web sites besides two (and...