all groups > sql server new users > march 2006 >
You're in the

sql server new users

group:

SQL 2005 SSIS Flat File Data Source


SQL 2005 SSIS Flat File Data Source G. Ray Giacalone
3/21/2006 4:41:42 PM
sql server new users:
Installed SQL 2005 Developers Edition including SSIS...when running the new
Import and Export Wizard all of the data sources come up in the Data Source
dropdown box except for Flat File Source :-[

How can I get the Flat File Source into my new installation for text file
imports?

Thanks!!!!!

RE: SQL 2005 SSIS Flat File Data Source Ronnie Miller
3/29/2006 1:52:05 PM
I'm having the same problem. I installed Sql 2005 without SSIS first, and
tried to import a text file, but it gave an error that looked like it wanted
SSIS installed. I then installed SSIS and 'Flat File Source' isn't in the
RE: SQL 2005 SSIS Flat File Data Source Ronnie Miller
3/29/2006 2:01:02 PM
One other interesting thing. I went into the B.I. Development Studio,
created a new project, went to the Data Flow tab, and clicked on 'No Data
Flow tasks have been added to this package. Click here to add a new Data
Flow task.' It gave the following error:

------------------------------
Registration information about the Data Flow task could not be retrieved.
Confirm that this task is installed properly on the computer.
------------------------------
ADDITIONAL INFORMATION:
TaskHost "{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}"' is not installed
correctly on this computer. (Microsoft.DataTransformationServices.Design)

I unregistered and reregistered the DTSPipeline.dll (found in the registry),
Re: SQL 2005 SSIS Flat File Data Source Will
4/4/2006 4:47:16 PM
I am also experiencing this, I have since tried repairing all of the
installs, and uninstalling and reinstalling to no avail. Please post a
resolution when you find one.

Thanks,
Will
Re: SQL 2005 SSIS Flat File Data Source Will
4/17/2006 6:58:52 AM
The Solution for me was to grant Users Group Read level Access to the
following CLSID registry keys and sub keys:


HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{1171A62F-05D2-11D1-83FC-00A0C9089C5A}

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{D27CDB6E-AE6D-11cf-96B8-444553540000}

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{D27CDB70-AE6D-11cf-96B8-444553540000}

then reboot.
Re: SQL 2005 SSIS Flat File Data Source Ronnie Miller
4/17/2006 7:08:02 AM
AddThis Social Bookmark Button