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.