November 16, 2009 at 9:07 am
Hi,
Any help would be much appreciated.
As of last week, I have been unable to run any SSIS packages which import from flat files.
I used SQL Server Management Studio, import wizard, and the Flat File Source option has disappeared from the drop-down list of sources.
I have uninstalled and re-installed but with no joy. Any ideas what may have happened?
Benny
November 16, 2009 at 10:28 am
Try adding the Flat File Source back to the Toolbox manually.
Open a Data Flow task.
Right-click in the Toolbox & select Choose Items.
Go to the SSIS Data Flow Items tab.
Check Flat File Source.
November 17, 2009 at 1:22 am
Hi,
Thanks for your response. I should have made it clear that the option appears there in the toolbox (although not in the management studio import wizard) and it is checked when following your instruction.
However, when I try to create a flat file connection (or run a package which uses one) I get errors:
The new connection manager could not be created.
The connection manager FLATFILE is not properly installed on this computer.
(Microsoft.DataTransformationServices.Design)
It's as if it has been de-registered. However, a re-installtion did not correct it.
Any other ideas about how I can specifically re-install it? It seems to be a local issue to my machine, as colleagues are ok.
November 17, 2009 at 2:21 am
I've found the following suggestions - just quoting what I've found, no guarantees.
1) Install SP2 of SQL Server 2005
2) Register "(path)\Program Files\Microsoft SQL Server\90\DTS\Binn\DtsConn.DLL" using RegSvr32.exe.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
November 18, 2009 at 1:50 am
Still no luck. I wasn't able to re-register the dlls. Thanks anyway.
I'm going to keep trying - deskside support have suggested a rebuild - not exactly a preferred or proportionate option!
November 18, 2009 at 1:53 am
Good luck - please post back if you find the solution.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
November 20, 2009 at 1:59 am
I re-visited this, and realised that SP2 wasn't installed on the client machine. So installing, and checking all the boxes has solved the issue.
I have no idea how the flat file soce became unregistered, or how to fix it if it happened again - until SP3 comes out 😉
However, it's avoided a re-build, so thatnks to all for their help.
🙂
November 30, 2009 at 9:58 am
If it happens again you could uninstall and re-install SSMS, then apply SP2.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply