Viewing 15 posts - 466 through 480 (of 579 total)
Dynamic code such as this is something my company try to practise and preach. In my current data warehouse project we have built a metadata layer that lists the warehouse...
February 17, 2005 at 6:10 am
Tim,
There is a migration wizard for existing packages. I have not used it myself, largely because the mapping between DTS functionality and SSIS functionality is so obscure I am fearful...
February 15, 2005 at 12:47 pm
Matt,
Thanks for your reply.
Your approach to using DTS is the one that alot of people take, certainly I know I do. And my company do steadfastly.
You are right that I...
February 15, 2005 at 12:44 pm
This feature IS available in Yukon. Its in SQL Server Management Studio.
Which release version are you on? It wasn't in earlier versions until people complained (loudly).
February 11, 2005 at 2:13 am
I would recommend that in future you try a different forum because your question has nothing to do with either SQL Server Yukon or Business Intelligence.
February 8, 2005 at 9:40 am
Eleanor,
I doubt whether you will find much help around here. SQL Server pros aren't going to be willing to help people "blag" a job in their profession because it kinda belittles...
February 8, 2005 at 9:35 am
This probably won't help you very much because you need a username/password to get onto them and if you had the username/password then you'd probably know about them but nevertheless:
microsoft.private.sqlserver2005.*...
February 4, 2005 at 1:49 am
In the ExecuteSQL task the '?' symbol is a placeholder for parameters. You can map parameters to these placeholders using the ExecuteSQL Task Editor dialog. Don't forget that if it...
February 2, 2005 at 2:13 am
Have you installed the latest service packs?
February 1, 2005 at 2:13 am
Great article Terry, I enjoyed reading it.
I'm interested in the following:
"I did come across a driver that could be used to directly access exchange as a linked server (I hoped)"
What...
February 1, 2005 at 2:11 am
Well spotted. Thanks David.
This is working fine which is great news.
January 28, 2005 at 7:37 am
Hi,
I *think* I've worked this out. Removing the first comma from the EXEC statement seems to have done the trick. I'm still not absolutely sure of what behaviour this exhibits...
January 28, 2005 at 4:38 am
I *think* the most widely available way of getting it is through being a TechNet subscriber. I'm not sure if its on MSDN yet.
HTH.
January 27, 2005 at 1:47 am
Paul,
This link:
http://www.sqlsummit.com/oledbVen.htm
takes you to a list of OLE DB providers and the sources they support. At a glance I could see that MySQL, PostgreSQL, Progress were listed on there...
January 25, 2005 at 11:12 am
Viewing 15 posts - 466 through 480 (of 579 total)