Viewing 15 posts - 361 through 375 (of 448 total)
Saw this happen to a manager of mine - he did a pretty good job of streamlining the servers, moving from individual desktop support to a Citrix farm, changing over...
April 26, 2006 at 9:21 am
Should have added in some details:
Users table for the NT Login and associated base information for that person - usually things like Phone/extension, First/Last name, Department, Role, etc.
We then branched...
April 24, 2006 at 11:50 am
I've seen that used before - one SQL login that is used to look up the data in a table containing users and similar. It works relatively well except for...
April 24, 2006 at 11:47 am
Well the files are all XML so it's possible that the variables are stored in a common place in all of the files. You could try to find them...
April 24, 2006 at 10:42 am
Why not use templates for this? I think that some of the SSIS blogs discussed using templates. They should work in a manner similar to other VS project...
April 21, 2006 at 2:35 pm
Might be in a different location - depends on where things were installed. Perhaps do a search for that file across all of your drives? It might not...
April 21, 2006 at 1:16 pm
When running a default instance of SQL 2000 and a named instance of SQL 2005, I ran into a problem with the configuration of SSIS where it uses the default...
April 21, 2006 at 12:51 pm
Haven't seen any e-books yet, but there are a couple of paper books. One was even co-authored by some of the regulars on this site:
"Professional SQL Server 2005...
April 21, 2006 at 12:31 pm
Could you extract to a working folder then process each file in the loop and move/delete the file at the end of the loop? Seems like that would be...
April 21, 2006 at 12:27 pm
One of the requirements was free. Thus Gzip or something similar. I don't think RAR is free, but it's an option.
LiteSpeed has a 2005 version ready. Not...
April 21, 2006 at 11:54 am
As Greg noted - if you right-click the DTS package and select Versions, you should be able to go back. However if multiple people are making the changes I...
April 18, 2006 at 11:23 am
If you want something free, Gzip may work. I won't say that it's fast, but I believe there are no limits on file size.
-Pete
April 17, 2006 at 9:23 am
You could also add some activex code to:
1. check for a file - if found, continue, otherwise exit successfully
2. At the end of the package or after processing...
April 13, 2006 at 1:04 pm
What about storing those in some sort of external file and using an expression to read them in? That should get around the issue of saving the password in...
April 13, 2006 at 12:14 pm
I don't think you're going to be able to create a DTS package with just OSQL. You can get a Developer copy of SQL Server for $50 or at...
April 12, 2006 at 9:30 pm
Viewing 15 posts - 361 through 375 (of 448 total)