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

bsmith 63193 (3/15/2016)

---

I am fairly new to BI and SSIS, but am currently working on putting together a data warehouse. I have read that using surrogate keys is a must...

Have you run a DBCC CHECKDB on MSDB?

I don't...

Jason-299789 (3/15/2016)

---

Phil Parkin (3/15/2016)

---

Jason-299789 (3/15/2016)

---

@yb751

The NULL will only be eradicated if there is a row with a non-Null value, in the same column.

See the code below, when aggregating on Account....

Indeed. Why make such...

Jason-299789 (3/15/2016)

---

@yb751

The NULL will only be eradicated if there is a row with a non-Null value, in the same column.

See the code below, when aggregating on Account.

DECLARE @myTable TABLE...