Viewing 15 posts - 106 through 120 (of 327 total)
I was under the impression DB Mail will only work with SMTP. Is SMTP enabled on the Exchange server and is it set up to accept annonymous connections?
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
November 21, 2008 at 6:26 am
Looks like someone goofed on this one 😉
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
November 13, 2008 at 6:27 am
Dejan,
Is it really necessary to get delegation to work? From my experience and from what I've read here and elsewhere, if there is a reasonable alternative, it does not seem...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
November 7, 2008 at 7:56 am
I can't help you with the double hop. I'm sure there are many of us who are frustrated with that limitation. If you have some really sharp network people, you...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
November 7, 2008 at 7:24 am
Where are you running the query from? If it is your desktop, you have the classic "double hop". Try logging onto to one of the servers and run the query....
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
November 7, 2008 at 6:15 am
The debugger still requires sysadmin and unlike previous versions, there are no extended stored procedures to grant execute on. In a lot of environments, sysadmin can't be granted for various...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
October 15, 2008 at 7:07 am
CU1 was released 9/23 (Tuesday) and brings the version to 10.0.1763
http://support.microsoft.com/kb/956717/
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 26, 2008 at 6:09 am
SSMS 2005 can NOT connect to SSIS 2008
SSMS 2008 can NOT connect to SSIS 2005
Thus the need to maintain both sets of client tools
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 18, 2008 at 7:05 am
Sorry - I meant to post this when I got it:
From Buck Woody:
No, the SSIS team has a different connection method that doesn’t allow us to connect with SSMS. I...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 4, 2008 at 2:58 pm
Create a job with step that uses the type Operating System Command (CmdExec) and schedule it.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
August 25, 2008 at 7:03 am
This is some code I cut out in pieces from a .Net program I cobbled together. We script out everything on a server every evening for recovery and DR. This...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
August 15, 2008 at 6:38 am
If you have an environment with more than SQL Server in it, you may need to use linked servers to connect to Oracle, DB2, etc for data.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
August 12, 2008 at 6:27 am
There is actually a very good article on this site and the author also added few other links:
http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/2795/
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
July 25, 2008 at 9:13 am
For the source columns that are numeric, you could use a Derived Column Transform in between the source and destination. Change the data type there rather than scripting.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
July 24, 2008 at 6:54 am
DTS and SSIS sample X number of rows to determine column widths. If the columns in the initial sampling are smaller than a column in later rows, the later data...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
July 24, 2008 at 6:34 am
Viewing 15 posts - 106 through 120 (of 327 total)