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 |
|
ewomack
Starting Member
33 Posts |
 Posted - 2010-08-10 : 16:06:02
|
Hello, I'm relatively new to SSIS (as will be apparent) and I'm trying to figure out how to use a flat file destination source for a source that's not there yet. So here's my basic package: 1. Send E-mail Message that "process has started" (Send Mail)2. Create Flat File from SQL Server Source (Data Flow 1)3. Sort Data (Data Flow 1)4. Create comma delimited flat file from extracted & sorted data (Data Flow 1)5. Move the file to a different folder (File System Task)6. Load data from file into a new SQL Server DB table (Data Flow 2)7. Flat File Source (Data Flow 2)8. Sort by ID (Data Flow 2)9. Load DB table (Data Flow 2)The problem arises at step 7 - the file isn't actually in the folder I want to grab it from when the package kicks off, so I'm getting errors before even starting. I can "fake it" by putting a file there and configuring the flat file source, but this doesn't turn out well, either. Can I pre-configure the flat file in some way so that SSIS knows that it will be there mid-way through the package?I'm guessing that this is a classic beginner's question...  Ed Womackwww.getmilked.com |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-08-10 : 16:09:22
|
| May be there is a reason....but...Why not just move the data from the SQL Server Source (Step 2) to the SQL Server Destination (Step 6)...why all the files in between? |
 |
|
|
ewomack
Starting Member
33 Posts |
Posted - 2010-08-10 : 16:12:09
|
| Thanks for the reply. Yes, that is a way around this, but then I thought of a bigger potential issue - can you include potentially empty sources half way through an SSIS package? Seems like this must come up, but maybe I'm just thinking too hard.Ed Womackwww.getmilked.com |
|
|
|
ewomack
Starting Member
33 Posts |
Posted - 2010-08-10 : 17:00:15
|
| I'm thinking now that this situation should never come up if the package is designed well... why ever grab an empty source? Design at the front end should eliminate this situation.Ed Womackwww.getmilked.com |
|
|
|
|
|
|
Loading data from an empty source