Viewing 15 posts - 7,066 through 7,080 (of 11,678 total)
You don't, this forum doesn't have those options.
May 26, 2012 at 1:36 am
It's the first one, source - conversion - destination.
It wouldn't really make sense to do the conversion after you've written the data to the destination, wouldn't it?
Maybe you should look...
May 25, 2012 at 6:16 am
SQLDBA360 (5/25/2012)
Just seeing if this works <envy> <envy> <envy> <envy>
You can have your hair cut too if you really want.
May 25, 2012 at 6:15 am
Koen Verbeeck (5/25/2012)
Be aware that this creates copies for those columns, so you need to...
May 25, 2012 at 3:32 am
OK, pull a data conversion component in the dataflow and convert the 3 columns to DT_STR.
Be aware that this creates copies for those columns, so you need to adjust the...
May 25, 2012 at 3:07 am
Either the source is unicode or the destination is.
But, you said the SSIS datatype is DT_STR (non-unicode) and the destination table is varchar (also non-unicode). Can you verify please?
May 25, 2012 at 2:51 am
anthony.green (5/25/2012)
So we can expect you to have tinnitus next week then Koen?
Probably 🙂
It's their Black Album tour, so they're playing the entire Black Album.
Awesome times ahead.
May 25, 2012 at 2:49 am
Well, congrats in advance.
I started a family a few years back, so this is my first festival in years.
May 25, 2012 at 2:34 am
I'll have a great time. It's with Metallica as well, so I'll be probably deaf next week.
May 25, 2012 at 2:29 am
Schadenfreude-Mei (5/25/2012)
Koen Verbeeck (5/24/2012)
michael vessey (5/24/2012)
can we also lose the 90s please - what is the correct parameter for that ?
As long as you keep all those grunge bands (Nirvana,...
May 25, 2012 at 2:21 am
It seems the metadata has changed somehow.
Open the OLE DB Destination, check the mapping and click OK.
May 25, 2012 at 1:23 am
Normally it shouldn't be an issue if the number of columns between source and destination is different (you should remove the extra column however to improve performance) and if the...
May 25, 2012 at 1:02 am
There are several options.
What do you want to do exactly?
May 25, 2012 at 12:47 am
I don't think it is a good idea to have changing metadata in SSRS.
When you create the report, the column names will be embedded into the report.
If those change, the...
May 25, 2012 at 12:40 am
Went with my gut feeling on this and got it right.
Great way to close the week.
May 25, 2012 at 12:34 am
Viewing 15 posts - 7,066 through 7,080 (of 11,678 total)