I strongly recommend you number the rows prior to import.

I'm sure there are tools available on the web that will add line numbers. I, personally, use a DOS batch file...

First: What's the reason to use SSIS for it?

Create a lookup table holding your website_name and your ordering number. Use something along "ROW_NUMBER() OVER (PARTITION BY email ORDER BY website_name_order)...

TIM.OGRADY (6/19/2010)

---

Is there a way to ensure that a flat file is loaded into sql in the exact sequence of the source file?

I am having a similar concern with a...

My pleasure 😀

Yes.

You could provide the primary keys as a comma separated list (without blanks) and use a split string function to covert that list into a table (search for DelimitedSplit8K on...

Stefan Krzywicki (6/17/2010)

---

However, even the standard datetime has that problem if you're not dealing just with England, America and other former English posessions. Russia used the Julian calendar until 1918,...

I don't think it has to do with the server upgrade...

it's more likely caused by the ISNUMERIC(ML.MISC_LAB_VALUE) = 1 function together with the CONVERT(DECIMAL...).

Reason: ISNUMERIC() will return 1 for values...

nikhil0416 (6/17/2010)

---

... Comparing two values of the Date data type will almost always perform better than comparing an int with a date value(in which case one has to be implicitly...

Glad I could help 😀

Jason Messersmith (6/17/2010)

---

I forgot to mention that this is in a data warehouse. so maybe it was to be able to join to a fiscal calendar quicker?

I...

There a several ways to get the quarter of a given date (in the order of my personal preference for result in an INT format):

1) use a calendar table that...

Stefan Krzywicki (6/17/2010)

---

...

If you can change it to a date column, I think you should. There may be others who can give you a good reason to keep it...

If you have any chance to get the money back from that "consultant": go for it!

It's one of the worst choices I've seen to store a date value. Even worse...

Unfortunately, it's a little more complicated, since SQL Server doesn't have a valid dateformat like the one you need to use as an input...

SELECT CAST(LEFT(@t,8) +' ' +SUBSTRING(@t,9,2)+':' +SUBSTRING(@t,11,2)+':' +SUBSTRING(@t,13,2)...

Please read and follow the first link in my signature.

Providing ready to use table DDL, sample data, expected result and what you've tried so far is the best way to...