Viewing 15 posts - 1,291 through 1,305 (of 3,232 total)
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...
July 22, 2009 at 1:28 pm
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...
July 22, 2009 at 1:19 pm
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?
July 22, 2009 at 1:04 pm
I don't think you post showed up as you expected. You may want to use the 'Preview' option before posting.
July 22, 2009 at 12:43 pm
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,...
July 22, 2009 at 12:41 pm
Are the range values in the other DB table derived from values in the data flow?
July 22, 2009 at 12:38 pm
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...
July 22, 2009 at 11:42 am
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...
July 22, 2009 at 11:39 am
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...
July 22, 2009 at 11:17 am
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...
July 22, 2009 at 11:07 am
bhanukbm (7/22/2009)
July 22, 2009 at 11:04 am
allen davidson (7/22/2009)
The stored proc would have 2 statements. In the stored...
July 22, 2009 at 11:03 am
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...
July 22, 2009 at 10:54 am
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...
July 22, 2009 at 10:51 am
You will probably get as many answers to that as you get posts. It would help a bunch if you could provide an example of how your table is...
July 22, 2009 at 10:48 am
Viewing 15 posts - 1,291 through 1,305 (of 3,232 total)