Source Databases Cannot Be Found
To whom it may concern,
When attempting to use SSIS Import and Export Wizard, no end user databases are being presented in the drop-down list, only the system databases are available for selection.
To ensure authenication is not an issue, I logged into SSMS and connected to the appropriate databases to be imported successfully.
At this point, I have no idea why only the system databases are made available instead of the end user databases.
Please help!
Thank you in advance for your assistance and support.
August 3rd, 2012 9:38am
Additional Information:
We are currently using,
Windows Server 2005 (Standard Edition) with SP1
SQL Server 2005 / SQL Server BIDS / Visual Studio 2005
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2012 9:43am
Wrong forum... Please post it under
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threadshttp://btsbee.wordpress.com/
August 3rd, 2012 10:05am
Hi Terry J. Ward,
Please check if the correct instance of SQL Server connects to? And how you configure in the SQL Server Import and Export Wizard?
For more details about it, please see:
Choose a Data Source (SQL Server Import and Export Wizard):
http://technet.microsoft.com/en-us/library/ms189667.aspx
Please feel free to ask if you have any question.
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
August 11th, 2012 11:41pm