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 |
|
darius_sutherland
Starting Member
17 Posts |
 Posted - 2009-03-25 : 07:26:15
|
| Getting a bit peeved at old SQL 2005I do a GUI export of certain tables to another database. I also at the end of all my options save this as an SSIS package which I want to call from an SP.**Now. This isn't the problem but I noticed it doesn't like saving the options you select when creating the package e.g Password details**Okay. So When I run the package via an SP or via the SQL GUI integrated services it fails. I find this ridiculous as it was SQL itself that save it and I just call it/execute it...ERROR :Column : Title Cannot be found at the datasourceOLE DB Source (1) failed the pre-execute phase.As I say. Don't get it as the package is a direct export from the Import Export Wizard.It's CRAP...Dwww.state-of-mind.co.uk | www.photographersinbrighton.org.uk | www.sussexweddingphotographers.org.uk |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-11-08 : 19:11:12
|
| Is your source a SQL server? Are you pulling directly from the table or are you getting data from a stored procedure? Are you pulling from any files? Out of curiosity, Why did you edit a post over a year old? |
 |
|
|
|
|
|
Save Eport Tables As SSIS. Fails When Run