Solved

How to create UDF file to be use by Microsoft data link

Posted on 2008-06-18
2
929 Views
Last Modified: 2013-11-30
I'm in the midst of creating my dts packages for data export and I would like to know when I choose for "Microsoft Data Link" in connection properties, what should be written in *.UDL? sorry never know how UDL file look alike and the format
0
Comment
Question by:motioneye
2 Comments
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 500 total points
ID: 21827912
Simply do the following:

1. Create a blank text file
2. Rename the text file extension to .UDL
3. Double click the file (it will open in the UDL editor) and fill in the property pages.

If you open the UDL file in Notepad you'll see the connection string that it has built.

Its a standard connection string
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now