derek.colley (11/23/2012)

---

My apologies Koen, it wasn't an insult to your code, but mine. And you have a point, yes - SQL Server should be sorting out the date format...

derek.colley (11/23/2012)

---

I'm sure there's a better way of doing this but my first instinctive thought would be to use a CASE statement as a computed column here.

I.e. something like:

DECLARE @dateTable...

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...

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...

Nice question to end the week. Thanks Ron!

In the source query, use the following TSQL:

SELECT myDate = REPLACE(CONVERT(CHAR(10),mySmallDatetime,103),'/','')

FROM myView

Unfortunately you can't.

You have...

Whoah whoah, you didn't read through all of the 38000+ posts before posting your reply? :w00t:

😛 😎

Welcome to...

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)....

You can use a Lookup component to check if the record exists in the destination or not.

In SSIS, you have to map the columns yourself in the destination component.

Happy Thanksgiving for the US folks.

Happy workday for all the rest 🙂

You can download the AdventureWorks databases from Codeplex:

http://msftdbprodsamples.codeplex.com/releases/view/59211

Nice question, thanks.

Explanation didn' mention snapshot though.

+2

If one answer says "it uses A" and another...