Viewing 15 posts - 6,166 through 6,180 (of 11,678 total)
derek.colley (11/23/2012)
November 23, 2012 at 3:29 am
derek.colley (11/23/2012)
I.e. something like:
DECLARE @dateTable...
November 23, 2012 at 2:31 am
Something like this:
DATEADD("dd",-1,DATEADD("mm",1,(DB_DATE)(myColumn + "01")))
edit: it's possible you'll have to do some more string manipulation on your data column before SSIS recognizes it as a date. SSIS is a bit...
November 23, 2012 at 1:25 am
You can store the resultset of the query in an object variable in the Execute SQL Task.
Loop over this variable using the For Each Loop. In each iteration of the...
November 23, 2012 at 1:21 am
In the source query, use the following TSQL:
SELECT myDate = REPLACE(CONVERT(CHAR(10),mySmallDatetime,103),'/','')
FROM myView
November 22, 2012 at 2:29 pm
eugene.goldberg117 (11/22/2012)
Correction-I did use Sql Server Import/Export GUI utility before.
What I'm really asking is: how to save the definition of such field mapping for the subsequent imports.
-Eugene
Unfortunately you can't.
You have...
November 22, 2012 at 1:03 pm
D.Post (11/22/2012)
Sorry skipped straight to my 2cents. (Nearly time to go home :-))
Whoah whoah, you didn't read through all of the 38000+ posts before posting your reply? :w00t:
😛 😎
Welcome to...
November 22, 2012 at 1:02 pm
With the Lookup task you will check if the person with ID 204 is already in the destination or not.
If it is, you retrieve the bonus column (call it bonus_dest)....
November 22, 2012 at 2:46 am
You can use a Lookup component to check if the record exists in the destination or not.
November 22, 2012 at 12:04 am
In SSIS, you have to map the columns yourself in the destination component.
November 21, 2012 at 11:32 pm
Happy Thanksgiving for the US folks.
Happy workday for all the rest 🙂
November 21, 2012 at 11:28 pm
You can download the AdventureWorks databases from Codeplex:
November 21, 2012 at 1:25 pm
Nice question, thanks.
Explanation didn' mention snapshot though.
November 20, 2012 at 10:55 pm
Meow Now (11/20/2012)
demonfox (11/19/2012)
After reading the file table, I fell on varbinary(max) ..need to read it again ..
thanks for the question..
+1 🙁
+2
If one answer says "it uses A" and another...
November 20, 2012 at 1:55 pm
Viewing 15 posts - 6,166 through 6,180 (of 11,678 total)