Posted
by user44885
on Server Fault
See other posts from Server Fault
or by user44885
Published on 2010-06-03T20:53:50Z
Indexed on
2010/06/03
21:05 UTC
Read the original article
Hit count: 150
I took over a SQL Server 2000 and need to fix a job that calls 3 DTS packages. How can I cross reference the DTSRun hash to the actual DTS name?
© Server Fault or respective owner
as seen on SQL Authority
- Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time.
My association with SQL Server Magazine has been quite long, I have written nearly…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hi,
I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager.
I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't…
>>> More
as seen on ASP-PHP.net
- Search for 'ASP-PHP.net'
Modification technique pour le site de l'article.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it.
We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error:
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections
What…
>>> More
as seen on SQL Blog
- Search for 'SQL Blog'
Another one of those might-be-useful-again-one-day-so-I’ll-share-it-in-a-blog-post blog posts I am currently working on a SQL Server Integration Services (SSIS) 2012 implementation where each package contains a parameter called ETLIfcHist_ID: During normal execution this will get altered when…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
List myList = new List
{
new Users{ Name="Kumar", Gender="M", Age=75, Parent="All"},
new Users{ Name="Suresh",Gender="M", Age=50, Parent="Kumar"},
new Users{ Name="Bennette", Gender="F",Age=45, Parent="Kumar"},
new Users{ Name="kian", Gender="M",Age=20, Parent="Suresh"},
new Users{ Name="Nathani"…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
public class SampleProjectData
{
public static ObservableCollection<Product> GetSampleData()
{
DateTime dtS = DateTime.Now;
ObservableCollection<Product> teams = new ObservableCollection<Product>();
teams.Add(new Product()…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
What is the easiest way to remove multiple DTS packages from SQL Server 2008?
Thanks.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am trying to run several DTS packages from a sql 2000 box. The DTS calls will originate from .net 2.0 - 3.5 code. I have been unable to find a good way to programmatically accomplish this. What I have read is running a sql job from a stored procedure that calls the DTS package. Does anyone has any…
>>> More
