Viewing 7 posts - 1 through 7 (of 7 total)
HI Hector,
You should be able to script out Sps and Jobs using enterprise manager. To script out the DTS packages as structured storage files, you can use the following stored...
January 17, 2005 at 9:10 pm
They have done it again!! The correct answer is 1 because the syntax should not have the comma after the last column has been defined!!!
October 21, 2004 at 7:59 pm
Thats bullshit man! there is nothing called as a Middle Join!! Try running it in query analyser and have fun!!
October 20, 2004 at 7:11 pm
re-boot the server! Thats the only way U can get rid of that!
September 21, 2004 at 8:56 pm
Yes you are right. But the hard coded value is stored on the report server. Users do not see that bit. Also in this case ( I could be wrong)...
March 25, 2004 at 1:40 pm
U could have an NT user with the right permissions on your SQL Sever/Database. Then configure the DSN on the report server.
Select "Credentials stored securely in the report server" and...
March 24, 2004 at 8:56 pm
Thanx rmarda. I know it can be done by scheduling the DTS package and then U can get the job that runs the package to notify in case of failure....
June 25, 2003 at 3:28 pm
Viewing 7 posts - 1 through 7 (of 7 total)