Viewing 15 posts - 9,196 through 9,210 (of 13,882 total)
annlcarey (7/14/2014)
Agreed. Rather than trying to keep track of the quotes, I use the tilde ~ to represent my single quote, then do a replace at the end.
Careful with that....
July 14, 2014 at 7:48 am
If you move a file to another folder after processing it, will the vendor put it back if it is within the seven-day period?
July 13, 2014 at 11:27 pm
gregwjohnston (7/11/2014)
July 12, 2014 at 12:39 am
Kenneth.Fisher (7/11/2014)
Yep it was covered extensively. But that's ok comments are always welcome 🙂
Extensively?! Sounds like that's my bedtime reading sorted out 🙂
July 11, 2014 at 7:25 am
Koen Verbeeck (7/11/2014)
...I think you need to use a more recent version number for the SQL native client.
+1
July 11, 2014 at 5:35 am
Apologies - I have not read all of the thread, so this may already have been covered.
It may be of interest to note that, although they are often confused, a...
July 11, 2014 at 3:40 am
I really don't understand the issue here.
Perhaps someone else in the forum can help you.
If you have source and target columns whose data types do not match, you may need...
July 10, 2014 at 12:02 am
Just for fun, you could also try DROP/CREATE.
July 9, 2014 at 12:03 pm
It's unlikely to be the reason in this case, but a server-level DDL trigger could probably make this happen.
July 9, 2014 at 11:37 am
gajayku (7/9/2014)
July 9, 2014 at 8:20 am
Database tables do not have an order. What is the problem, exactly?
July 9, 2014 at 8:13 am
neltonk (7/7/2014)
July 7, 2014 at 5:24 am
Evil Kraig F (7/3/2014)
July 4, 2014 at 4:36 am
sql server developer (7/3/2014)
I'm trying to load data from multiple files into SQL server using Foreach Loop Container in SSIS 2008. All the files are in the same format...
July 3, 2014 at 12:43 pm
I really wouldn't do that bit in SSIS.
Do it in T-SQL instead as a UNION. Something like this:
select participant_key
,participant_key2
,participantPosition = 1
,participant_1
,participant_rate
,participant_rate_high
,source
,date
from dbo.stage
union all
select participant_key
,participant_key2
,participantPosition = 2
,participant_2
,participant_2_rate
,participant_2_high
,source
,date
from dbo.stage
where participant_2 is not...
July 3, 2014 at 12:39 pm
Viewing 15 posts - 9,196 through 9,210 (of 13,882 total)