Skip to main content

Posts

Showing posts from May 26, 2010

SQL Server Import and Export Wizard

Yesterday, I was to Upload very large data. So I opened my Sql Server management studio & tried Import/Export wizard. & Surprise !!, I was not able to start Import/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: Cannot create a task with the name "STOCK:PipelineTask". Verify that the name is correct. ({1A768FBA-F8F7-4147-B1CD-2953FAC6781E}). I searched the  DTSPipeline.dll  in GAC (Shared Assembly folder). But there are both MSIL & x86 version. After that I searched Program Files SQL Server folder & found the above dll. I just registered this dll & my problem has been resolved. Regsvr32.exe "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtspipeline.dll" Above command will register the required dll. Thanks, Anuj Rathi