This could cause you some serious problems. Until you become able to change anything, here are two possible solutions, but try to convince someone to authorize the change.

SELECT *

FROM Table1...

Why would...

Just another way to do it. The Tally is just to generate the sample data and has nothing to do with the solution.

WITH Tally AS(

SELECT TOP 60 ROW_NUMBER() OVER(ORDER BY...

Are you just using integers with values from 0 to 99? Or Are you going to have values like '01', '12', '123', '57246' ? because you might want to add...

You need a variable that has scope for the whole package. Assign the filename to the variable look for the Property "Expressions" in the connection properties. In there you can...

You need to add an ELSE to your CASE statement. I'm sure you don't need separate conditions even if it becomes more readable.

SELECT name,

address,

...

Check the following article. It explains the method you might need.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

You should better use TRY...CATCH which is available since 2005

TRY...CATCH (Transact-SQL)

Using TRY...CATCH in Transact-SQL

What's your problem? I don't understand what you need.

Installing the Oracle Client and adding the service to TNSNAMES.ORA was all that I needed to connect to an Oracle db. Other problems involved network/firewall permissions.

Please post DDL, sample data and expected results so we can give you better responses by working on something that will actually look like your real data.

For guidance, please read...

I'm giving a shot in the dark here, based on many assumptions. Please post DDL and sample data as explained on the article linked in my signature for better help.

WITH...

Does this example helps you?

WITH Time_Windows(StartTime, EndTime) AS(

SELECT DATEADD( HH, 20, DATEADD(DD, DATEDIFF(dd, 0, GETDATE()) - 7, 0)),

DATEADD( HH, 11, DATEADD(DD, DATEDIFF(dd, 0, GETDATE()) - 6, 0))

UNION ALL

SELECT DATEADD( HH,...

Here you go

DBHammer

Have you tried it?