hello,
i'm trying to import data from an excel file to a SQL Server 2005 table using the Integration Services Project. i have Visual Studio 2005 installed
as i drag the data flow task and double clicking it, i get the following error
then i googled, i found a way that i should change the way Integration Services log on to my computer through the SQL Server Configuration Manager > SQL Server Integration Services > Properties > Log on tab > This Account and enter the username name and password that i use to log on to my computer.
but, then i get the following error
how can i solve this problem?
Thank you.
i'm trying to import data from an excel file to a SQL Server 2005 table using the Integration Services Project. i have Visual Studio 2005 installed
as i drag the data flow task and double clicking it, i get the following error
Code:
The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.
but, then i get the following error
Code:
WMI provider error: Invalid Parameter [0x80041008]
how can i solve this problem?
Thank you.