Viewing 15 posts - 10,096 through 10,110 (of 13,874 total)
What version of SSIS are you using?
I sympathise. Can you confirm that you have got to the point where:
a) Package 1 works.
b) Take a copy of package 1 (as...
February 26, 2013 at 6:23 am
sistemas_casinomnes (2/26/2013)
For example I have to send (248/5)*30 to a store procedure or to a function and the sp or the...
February 26, 2013 at 5:53 am
YarHad (2/26/2013)
Is there way to in SSIS to delete the contents of a text file before importing data into it? Just how you can truncate a table before...
February 26, 2013 at 4:00 am
When you copy a package, there are a couple of things you should do which may help minimise meta data issues:
1) Use File/Save As from within BIDS rather than doing...
February 26, 2013 at 3:40 am
Mackers (2/26/2013)
Just out of interest, how would that work if you wanted to change the database name?Mack
Which database name?
Obviously, the stored proc has to live in a known location and...
February 26, 2013 at 3:35 am
Mackers (2/26/2013)
February 26, 2013 at 3:26 am
OK, I'm not getting any closer to understanding what you want.
Can you provide some sample data showing what you currently have and what you want to have?
February 25, 2013 at 7:32 am
If you put the Excel file on a local (to the server) drive, do you get the same error?
February 25, 2013 at 6:01 am
latingntlman (2/25/2013)
February 25, 2013 at 5:58 am
mbrady5 (2/22/2013)
What I was thinking about doing is adding a week and year...
February 22, 2013 at 1:16 pm
Yeah that makes sense.
I don't think it matters much where you put it - maybe between (4) and (5) would work well.
Regarding the lookup itself - will there be an...
February 22, 2013 at 12:59 pm
Sounds like a textbook use for the lookup transformation to me - go for it.
Do you have specific questions about how to set things up?
February 22, 2013 at 12:43 pm
sameerarjuna (2/21/2013)
I have been reading books and reading online for the past few days and created a...
February 22, 2013 at 2:02 am
Debbie Edwards (2/21/2013)
My problem is that my folders arent on the C drive but...
February 21, 2013 at 6:46 am
mister.magoo (2/21/2013)
Phil Parkin (2/21/2013)
Alternatively, add a Conditional Split in the data flow and split the data into four streams - to four separate files.
I like this idea, but only if...
February 21, 2013 at 2:20 am
Viewing 15 posts - 10,096 through 10,110 (of 13,874 total)