Viewing 15 posts - 7,156 through 7,170 (of 11,678 total)
SSIS doesn't support changing metadata.
You'll need to create a seperate dataflow for each distinct set of metadata.
Regarding the filename:
in a for each loop you can specify a wildcard for the...
May 10, 2012 at 7:05 am
Brandie Tarvin (5/10/2012)
I mean, really, Oracle? What horrible thing has infected this place?
I'm working as fast as I can to get rid of it 🙂
May 10, 2012 at 6:41 am
L' Eomot Inversé (5/10/2012)
Jeff Moden (5/10/2012)
Koen Verbeeck (5/9/2012)
GilaMonster (5/9/2012)
Koen Verbeeck (5/9/2012)
Is this an Oracle thing?No, don't touch that myself.
Normally I don't either, but someone has to convert all that...
May 10, 2012 at 3:46 am
Jeff Moden (5/10/2012)
Koen Verbeeck (5/9/2012)
GilaMonster (5/9/2012)
Koen Verbeeck (5/9/2012)
Is this an Oracle thing?No, don't touch that myself.
Normally I don't either, but someone has to convert all that PL/SQL to T-SQL...
Neh......
May 10, 2012 at 12:53 am
Regarding point 3: open the package using BIDS (Business Intelligence Development Studio), run it and see where it fails. Fix it 🙂
This is only possible if you don't use Express...
May 10, 2012 at 12:07 am
What is the length of the column in the source and what is the length of column in SSIS?
ps: all the people on this forum are unpaid volunteers, who take...
May 10, 2012 at 12:03 am
vinu512 (5/9/2012)
Suresh B. (5/8/2012)
differences between seek and scan in sql serverThanks for the link Suresh. It was very INFORMATIVE. :-D:hehe::-D:hehe:
Give a man a fish and you feed him for a...
May 9, 2012 at 11:55 pm
Good question, learned something.
However, the question itself was a bit weird to read (at least for me, a non-native English speaker). I had to read it a few times to...
May 9, 2012 at 11:49 pm
GilaMonster (5/9/2012)
Koen Verbeeck (5/9/2012)
Is this an Oracle thing?No, don't touch that myself.
Normally I don't either, but someone has to convert all that PL/SQL to T-SQL...
May 9, 2012 at 11:41 pm
GilaMonster (5/9/2012)
Your doing it wrong.......
Why use one update where 4 will do?
Is this an Oracle thing? I've seen this a lot lately in Oracle code.
(and unfortunately, also in SSIS packages...
May 9, 2012 at 11:32 pm
How does such a filename look like?
May 9, 2012 at 11:23 pm
May 9, 2012 at 12:37 am
This is what I do:
put a for each loop with a file enumerator on the source folder and specify a wildcard in the filename.
Specify that the full path should be...
May 9, 2012 at 12:18 am
You don't need a script. You can specify a wildcard in your For Each Loop container.
For example:
myExcelFile*.xls, where * takes place of the timestamp.
May 8, 2012 at 11:57 pm
Viewing 15 posts - 7,156 through 7,170 (of 11,678 total)