You are using the Import/Export wizard?

There are probably other methods, as usual.

This one was the first I could come up with.

Add HAVING SUM(WIMAgedBalances.Tot30d) + SUM(WIMAgedBalances.Tot60d) + SUM(WIMAgedBalances.Tot90d) > 0 after the GROUP BY.

Since you are using IIF I can safely assume the code is for SQL 2012 or later 🙂

DECLARE @Date DATE = '20130217'

SELECT IIF(MONTH(@Date) <= 3, DATEFROMPARTS(YEAR(@Date)-1,4,1),DATEFROMPARTS(YEAR(@Date),4,1));

Pain in the *ss.

Or a kebab sandwich, whatever you prefer. 🙂

Maybe you should mention this in your original question.

You'll need to write some dynamic SQL: create a string variable large enough to hold the different SELECT statements that I wrote...

DECLARE @param varchar(1000), @param1 varchar(1000), @param2 varchar(1000), @param3 varchar(1000);

SELECT @param = value FROM #temp WHERE Name = '@para';

SELECT @param1 = value FROM #temp WHERE Name = '@para1';

SELECT...

If you want to debug the script task, you need to set a breakpoint inside the script task.

Breakpoints in the control flow are for debugging the package itself. If the...

You can see a connection manager as a factory creating connections.

Each time a connection manager is used by an SSIS component, a new connection is created.

If you set RetainSameConnection to...

How does the query look like? Do you use any parameters?

gurjer48 (1/16/2014)

---

whats your opinion on ssis ???

i am working as report developer ??

I have 1 1/2year exp in ssrs reports and

now recently i joined ssas and ssis job??

is...

You are retrieving only filename and extension, so the folder is missing.

In the for each loop you can choose to retrieve the fully qualified path. Take that one.

Easy one to end the week, thanks.

I would first create a new SSIS 2005 project and add some existing packages to it. Start small, don't add everything all at once.

Start with the easiest packages.

Then open your...

Evil Kraig F (1/16/2014)

---

Koen Verbeeck (1/16/2014)

---

If you have to compare all columns, just calculate a hash over all those columns and store it alongside in the table. Then you can...