FredS (7/22/2009)

---

Thanks. I'm using MSSMS 2008. It doesn't give me an option to script an alter cscript. It does let me go to design.

I have only a...

Ah, now that's another story! Depending on your protection level settings, the setup is different. I prefer to store the packages in SQL Server, use configuration files to...

OK, here's what I'd do:

Create a Data Flow with the following contents:

1. Flat File Source adapter to get your file info into the data flow.

2. Lookup Transform. Use the...

Where are you storing the SA password? If you open the connection manager up, type in the sa password, and press the 'Test Connection' button, does it connect?

I don't think you post showed up as you expected. You may want to use the 'Preview' option before posting.

Did you change something w/ the desintation properties? You didn't by chance change the destination properties expression instead of the source did you?

Can you tell me what object, property,...

Are the range values in the other DB table derived from values in the data flow?

Yep, I didn't catch that part. Jeff's solution will give you the top 10 for each ID.

As a side note, any time my answers differ from Jeff's -----go with...

No problem. Using staging tables and procedures is not necessarily a bad thing, but it too often the first choice for SSIS developers. SSIS was designed so that...

First of all, you don't need a for each loop if you only want to load one file for each package exectution. I would create a data flow with...

Much of this depends on what you are trying to change with the structure. Droping/recreating the table may be overkill and unnecessary. A simple ALTER TABLE statement works...

bhanukbm (7/22/2009)

---

Thanks for quick reply. I am working on one SSIS package right now and have the situation where the insert is very simpele , that is if it...

allen davidson (7/22/2009)

---

I would probably load the file to a staging table and then perform the insert/update in a stored proc.

The stored proc would have 2 statements. In the stored...

I'm sure there's more to the story. Why not just pass the Condition value in as a varchar parameter? Are there other attributes in your XML that you...

So do you have a specific question on a problem or challenge that you are facing in your data flow? Or do you just want general guidence on how...