Database import error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database import error

Hey guys!!! Please help me with this, when i try to import a database made in access to sql server 2005 i get the following error…. TITLE: SQL Server Import and Export Wizard —————————————- The SSIS Data Flow Task could not be created. Verify that DTSPipeline.dll is available and registered. The wizard cannot continue and it will terminate. —————————————- ADDITIONAL INFORMATION: Value does not fall within the expected range. (Microsoft.SqlServer.DTSRuntimeWrap) —————————————- BUTTONS: OK —————————————- It worked fine, but i had to uninstal SQL and when i installed again i came across this problem….
plz plzzzz… do resolve this issueee .. ive two months for the project and im stuck with this thing for the last 2 weeks at initial stage.
check whether this help you
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21773487.html?qid=21773487 —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
Are you running on any of the BETA products of VS & SQL SErver 2005? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Nops no beta versions…Infact i cant seem to use sql 2005 and vs 2005 on the same machine, is that so? installing of vs 2005 requires you to uninstall sql native client ans vice versa. Its an SSIS issue i guess.. and i cant find that in configuration manager, plus DTSPipeline.dll is available too.
Check through this documenthttp://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx to deploy SSIS as mentioned. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>