Viewing 15 posts - 271 through 285 (of 313 total)
Wow that is a lot of stuff
We recently did an accounting cube (Snowflake). This is what we did
GL Entry was the fact
The Account structure was difficult but since it...
February 20, 2006 at 4:17 pm
When I did the install it was required. It just created a local server on my machine. Not sure how to get around it. Sorry. I...
February 20, 2006 at 2:53 pm
Don't give them SQL server. Just give them Visual Studio. They can design, troubleshoot, and run queries from there.
February 20, 2006 at 2:46 pm
What I use to launch a DTS from an application is a PROC
exec master.dbo.xp_cmdshell 'DTSRUN /S Server /U User /P Password /N IMPORT_Distributor_Sales_Fact',
February 20, 2006 at 2:35 pm
I will look into that. not sure if it will work on this case. But maybe.
February 15, 2006 at 3:38 pm
I am not quite sure what you are talking about or how to solve your issue. What I have found to be of value when something blows up in my...
February 15, 2006 at 10:49 am
I had the same issue. I posted the error in the forums and everyone told me to import to Access. If it works there then export it again and try...
February 15, 2006 at 10:39 am
Also this is the error
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'WITH'.
Msg 170, Level 15, State 1, Line 22
Line 22: Incorrect syntax near '('.
January 20, 2006 at 12:57 pm
I would use the 2K method and use a Stage table. Something you can control. that way you can do all your validation locally
January 20, 2006 at 11:26 am
I do not think you can do that unless you had an ability to read an e-mail. Either move it there through cmdshell or FTP through CmdShell.
January 20, 2006 at 11:24 am
Also what I did find is that most stuff works normally. The only thing jacked up is the manifest and occasional errors. If you upload the DTS from a 32...
January 20, 2006 at 11:21 am
I had the exact same issue with a server I am working with. When I installed the 64 bit the issue went away. I could not find the actual problem
January 20, 2006 at 11:16 am
Please do since we also use Biztalk and I was not aware there may be an issue
January 20, 2006 at 11:14 am
| Windows 2003 Server Standard x64 |
| Dual EMT64 Xeon Processors 3.00 GHz (64-bit) |
| Dual Redundant Power Supplies (Hot... |
January 20, 2006 at 11:08 am
Viewing 15 posts - 271 through 285 (of 313 total)