Viewing 15 posts - 1 through 15 (of 20 total)
With or without a password, a user should not have the SA user id and it should never be in an INI file. I hope it is at least encrypted.
May 13, 2004 at 7:33 am
Another possible option (although I don't recommend having an automated production run use a developer's PC) would be to use UNC notation (eg. use \\gslnt8456\c$\firstlevel\secondlevel\input.mdb instead of c:\firstlevel\secondlevel\inout.mdb...
August 20, 2003 at 8:26 am
Always Export the file to the same location and then based on parameters, use XP_CMDSHELL to copy or move it to another directory.
August 19, 2003 at 6:52 am
Please be more specific here. Are you talking about packages or the application (enterprise manager)?
August 18, 2003 at 2:27 pm
We had this problem in SQL 7.0 SP1. Unused connections would be orphaned when the last icon was deleted. After we applied SP3 we were able to remove...
August 18, 2003 at 2:24 pm
Kimball -- Ralph Kimball is one of the original designers of Data Warehousing. His approach is using Fact and dimension tables in a star schema (snowflake if it gets...
August 4, 2003 at 12:03 pm
We are currently phasing out our load as we were bought by another company.
We use to take 8-10 hours to load and by modifiying the Kimball approach we were able...
August 4, 2003 at 7:56 am
We use sp's and DTS to do our DataWarehouse and I couldn't be happier. There is a learning curve but that is due to data warehouse itself (facts and...
August 1, 2003 at 2:04 pm
Try this thread (you may have to piece it back together) -- it seems to be closely related to your question.
August 1, 2003 at 1:58 pm
Very good point Mr. DavidBurrows! I myself always use courier as it is a non-proportional font.
August 1, 2003 at 7:21 am
use a stored proc as your source in the set location. Although the code is not in crystal it is far more efficient to have it in a stored...
July 30, 2003 at 1:59 pm
That table is only in 2000. It is not in 7.0
July 30, 2003 at 9:40 am
Works like a charm for me. I send files to a mainframe all the time with nulls and fixed length. I even wrote a one timer this morning...
July 30, 2003 at 9:26 am
When defining the destination file you have the option of fixed or delimited. If you pick fixed then the nulls will come out as spaces and your columns will...
July 30, 2003 at 7:40 am
Viewing 15 posts - 1 through 15 (of 20 total)