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 |
|
nfleetos
Starting Member
3 Posts |
 Posted - 2008-08-18 : 15:20:07
|
Greetings everyone,First-time poster here.  (waves hello) I have a Microsoft SQL Server 2005 package that was written by someone. It takes a list of names and does fuzzy matches on them against a database. The person linked it to the wrong database, and then they went on vacation.  My question is: how can I import a SAS database into the package, allowing me to compare the list of names against the new database?I would be obliged to receive any help. Cheers, Nikolaus |
|
|
nfleetos
Starting Member
3 Posts |
Posted - 2008-08-18 : 15:22:09
|
| I failed to mention that I am a rank beginner when it comes to SSIS. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-18 : 23:08:05
|
| Check connections in the package, you can either modify them or create new one to point to your db. |
|
|
|
nfleetos
Starting Member
3 Posts |
Posted - 2008-08-19 : 09:43:01
|
| Thanks, it happened to be a connection problem in the package and another issue--I imported the data into an MS Access table first, and then I pointed the package to there. |
|
|
|
|
|
|
Request for help--importing SAS data