Unthreaded, ascending Unthreaded, descending. I transfer data from a 3rd party non SQL server database using both methods. David Burrows Posted 14 years ago You can’t post new topics. However using openrowset is a simple as the examples outlined below: You can’t delete other topics.

Uploader: Takinos
Date Added: 28 December 2012
File Size: 37.42 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 42501
Price: Free* [*Free Regsitration Required]

That must be the best answer I’ve ever had in any Forum, thanks a lot, David!! Far away is close at hand in the images of elsewhere. I always save the package first with a reasonable name.

I’m just guessing, but I have the odbc driver for Solid server, and I’ve made the dsn for it. Anthony Ivins Posted 14 years ago You can’t delete other topics. You can’t edit your own posts.

How can I make connection to a Solid DB?

How can I make connection to a Solid DB? For further information in relation to openrowset, refer to the SQL Server books on line. You can’t edit other topics. You can’t post new polls. You can’t vote in polls. Keep up to date – daily newsletter:. Once saved you can load it by expanding the Data Transformations Services folder and double clicking solidb the package name.


I have never used a solid database. You can’t post topic replies. Providing the ODBC driver is compliant and able to support this.

How can I do this? Post reply Like 15 Add to Briefcase. You can create job to so,iddb the the DTS and schedule it to run once a day. I want to do a timed procedure, which starts once a solifdb and gets data from a Solid server db and puts it to SQL Server db.

You can post emoticons. This helped me a lot! You can’t post replies to polls. You can’t delete your own topics. Nex question will be, what is DTS?

Narrow your search by forum. You can’t delete other posts.

And how can I make a job? You can read topics. This is not complete but will get you started. And where do I put the dsn of my non SQL server db?

IBM Where are the solidDB® ODBC Drivers for Connect:Direct? – United States

You can’t post IFCode. I understood that quite fast. You can’t edit other posts. However using openrowset is a simple as the examples outlined below: You odbcc edit your own topics.