Not Able to Import anything.

Pranshu Saini 0 Reputation points


The ConnectionString property has not been initialized. (System.Data)

Program Location:

   at System.Data.Odbc.OdbcConnection.PermissionDemand()
   at System.Data.Odbc.OdbcConnectionFactory.PermissionDemand(DbConnection outerConnection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.Odbc.OdbcConnection.Open()
   at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
   at Microsoft.SqlServer.Dts.DtsWizard.Step2.OnLeavePage(LeavePageEventArgs e)

I have Installed the Integration Tools on the SQL server (Developer), and still, It's not working properly. I have seen many related articles but none were helpful.

I have also tried SQL express and that was way worse. I had no idea Microsoft SQL server was this confusing and time-consuming.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,141 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,854 questions
{count} votes