Viewing 15 posts - 7,336 through 7,350 (of 13,876 total)
Tava (4/4/2016)
I've had a quick read, I'm a little confused... The values of 4,8,30,N... will be passed via the #temp table i created.
Since I'm using an outer apply in this...
April 4, 2016 at 6:01 pm
April 4, 2016 at 5:27 pm
SQLTougherGuy (4/4/2016)
Hi Phil - I am using 2014. Which other methods do you recommend for this?
I recommend the following:
a) Use the project deployment model, to take advantage of the benefits...
April 4, 2016 at 5:23 pm
LinksUp (4/4/2016)
Or change the delimiter to something that should not ever be in the source data like a pipe | or tidle ~.
'Tiddled' is what I was last Friday night....
April 4, 2016 at 5:17 pm
swansonm (4/4/2016)
contract lineitem effectiveDate termDate rate
1234 1ITEM110/12/20054/4/2016...
April 4, 2016 at 5:15 pm
larry.andrews (4/4/2016)
Similar behavior - deployed to the server or running in VS (on the server).
OK. I was wondering whether the VS debug overhead might have been a factor, but it...
April 4, 2016 at 2:31 pm
Which version of SSIS are you using?
If 2012 or later, there is no need to use a config file for this.
April 4, 2016 at 2:16 pm
sqlbaby2 (4/2/2016)
**Please delete the post as...
April 3, 2016 at 5:44 am
Luis Cazares (4/1/2016)
You need to use a format file to identify the quotes as part of your delimiter. BCP won't remove the quotes for you otherwise.
Or run an UPDATE query...
April 1, 2016 at 2:14 pm
We have many projects that we run in 2014 Developer mode
What do you mean by this?
April 1, 2016 at 1:12 pm
SQL!$@w$0ME (4/1/2016)
What is the...
April 1, 2016 at 1:06 pm
larry.andrews (3/31/2016)
I'm observing significant performance differences depending on how a child Package is launched.
Scenario 1 : Single Master Package calling Specific Packages
Scenario 2 : ETL...
April 1, 2016 at 5:24 am
Is the file path local to the client, or the server?
March 31, 2016 at 2:03 pm
Very clever indeed. How would this be applied against a column in a table?
With some difficulty. I tried a few ideas & failed. Looking forward to seeing someone else...
March 31, 2016 at 10:42 am
mister.magoo (3/31/2016)
Why aren't you just doing this:
INSERT INTO [Table] (UserID, RefID, NewValue)SELECT UID, RefID, 'Fixed message'
From UserTable
Where <Some condition>.
Exactly what I was wondering.
March 31, 2016 at 8:01 am
Viewing 15 posts - 7,336 through 7,350 (of 13,876 total)