Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 988
  • 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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