What is CRL?

Instead of

set @START_DATE = @START_YEAR + '-' + @START_MONTH + '- 01 00:00:00'

set @END_DATE = @END_YEAR + '-' + @END_MONTH + '- 01 00:00:00'

Try this:

set @START_DATE = try_Parse(@START_YEAR...

Please post the full text of the error message.

Igor Micev (3/18/2016)

---

The catalogs databases are small and don't keep...

I agree with all of John's comments. Lots of memory and speed of connection to data sources would be high on the list.

Actually, no.

1/0.0033 = 303.03030303......

hardly a round number.

300 ticks per second = 3.3 recurring milliseconds

ScottPletcher (3/17/2016)

---

Phil Parkin (3/16/2016)

---

DATETIME is stored internally in SQL Server as the number of days since 1/1/1900 (the integer part) plus (I think) a decimal part representing the number of...

Dynamic SQL is not necessarily required – "long-winded SQL" can avoid it. For example:

DECLARE @Col varchar(10);

SET @Col = 'Col1';

--set @Col = 'Col2';

IF Object_Id('tempdb..#Test','U') IS NOT NULL

DROP TABLE #Test;

CREATE TABLE #Test...

manoj.kumar-1078069 (3/17/2016)

---

The solution can be made generic and automated:-

1) Keeping text file as source (1 column) Load it in a recordset destination using dataflow

2) Loop over the record set and...

DATETIME is stored internally in SQL Server as the number of days since 1/1/1900 (the integer part) plus (I think) a decimal part representing the number of 300ths of a...

pjk_tgk (3/16/2016)

---

The source tables reside on different servers. One server is AS400 (6 tables, many contain over 10 million records), one server is MySQL (one table). SQL Server 2008 is...

Don't know about the *best* way, but one...

sqlnewbie17 (3/15/2016)

---

I have already built the package.It works fine as long as the servers exists.

Lets say a server is not reachable for any reason.My foreachloop should skip that server and...

Not directly.

But you can handle it with some code. Import every row as a single column and then send that through a Script Component to parse out the relevant columns.

If you are open to alternative ideas, have you considered creating a table of 'selected customer numbers', which can be repopulated every time the job runs?

The table, or tables, would...