• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1005
  • Last Modified:

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

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
motioneye
Asked:
motioneye
1 Solution
 
nmcdermaidCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now