Viewing 15 posts - 121 through 135 (of 327 total)
The report project file will have an extension of .rptproj. You might try doing a wildcard search for the *.rptproj
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:10 am
From BOL:
If you want to run a package from a 64-bit SQL Server Agent job in 32-bit mode, select a job step type of Operating system, and enter a command...
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 18, 2008 at 9:46 am
It looks like the package is running in the 64 bit environment. Packages on a 64 bit server need to run in the WOW layer (32 bit) since SSIS is...
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 18, 2008 at 9:39 am
One simple thing I'd like to do is just print a list of the package variables, and their properties. Is there an easy way to do that?
I'm...
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 14, 2008 at 8:42 am
in Houston, only people with death wish are bikers
You're not kidding. I moved to Houston in '94 from CO. After getting here, I realized I would get killed if...
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 10, 2008 at 11:28 am
Let's hope none of your commutes are along the Cross Bronx Expressway in NYC - parts of it are congested over 90 hours a week! They should call 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.
July 10, 2008 at 6:54 am
Actually this is exactly what I have done. I had a look at sp_send_dbmail but I couldn't see how you set the "from" value. This mechanism will be used by...
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 10, 2008 at 6:26 am
I think the problem is that there is no 64 bit Jet driver and packages that need Jet have to run in the 32 bit WOW layer. I vaguely remember...
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.
June 18, 2008 at 6:45 am
We had MSFT give a class in Power Shell. All of .Net, WMI and more is accessible which means you can do everything in PS. Scripting in PS will probably...
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.
June 11, 2008 at 7:20 am
Steve,
I won a copy also and since it is a licensed copy, I have been checking for and receiving regular updates. I now have the latest version and don't...
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.
June 6, 2008 at 6:25 am
Sorry - I forgot that the less than and greater than symbols are for html tags so it come out right
ALTER TABLENAME
ALTER COLUMN ...
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.
May 9, 2008 at 1:15 pm
sharma (5/8/2008)
I did
ALTER TABLE NVARCHARTBL
ALTER COLUMN NAME COLLATE default
The above query is correct?
Bcoz It shows error
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword...
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.
May 9, 2008 at 7:14 am
jpeables - hmmm - I never noticed that. You would think MS wouldn't miss something like that. :ermm:
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.
May 9, 2008 at 6:41 am
that is because you don't have SP2 installed. I asked earlier if this was a desktop client or a server.
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.
May 9, 2008 at 6:25 am
to change the defaults for generating scripts, from the Menu bar select Tools, then options. The Options window should have scripting in the tree. Select it and change the defaults...
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.
May 9, 2008 at 6:16 am
Viewing 15 posts - 121 through 135 (of 327 total)