Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simflex
Constraint Violating Yak Guru
327 Posts |
 Posted - 2008-03-13 : 15:20:47
|
| Greetings everyone.I am relatively new to SQL2005.During the SQL2005 installation on the on one of our servers, a component of SQL2005 was apparently not checked for installation. As a result, it was not installed. That component is called SSIS.At least that's what my research said.As a result, anytime we would attempt to import flat file (txt), it would fail with some SSIS package error.We communicated this to our SQL Admin and he said he had reinstalled the SSIS component.Yet, we are still having the same problem importing flat files.2 questions:1, Is there a way to verify that SSIS has or has not been installed?2, Is it really the reason a flat file could not imported?Thanks for your help |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-13 : 15:27:36
|
| Tell you Sysadmin to check :SQl server configuration manager and check SSIS services is enabled or not.Did he reboot the server after he installed the component? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-13 : 22:38:46
|
| >> Is it really the reason a flat file could not imported?You can load data from file with bcp or bulk insert. |
|
|
|
|
|
|
How can you tell that SSIS has been installed?