7 votes
Accepted

SSIS OLE DB Source Editor Data Access Mode: "SQL command" vs "Table or view"

I will make a small experiment. i will use SQL profiler to see what is going in the background while using an OLEDB Source in the two cases: I have a Table named dbo.Table_1 that contains 3 columns (...
Hadi's user avatar
  • 1,222
2 votes

SSIS 2008: Illegal characters in path when trying to rename a file

\\\\servername\\csv\\BACKUP\\" + (DT_WSTR,4)DATEPART("yyyy",GetDate()) + RIGHT("0" + (DT_WSTR,2)DATEPART("mm",GetDate()) ,2) + RIGHT("0" + (DT_WSTR,2)...
Bee_Riii's user avatar
  • 165
2 votes
Accepted

SSMS 10.5 alongside 17.7

You can use the latest version of SSMS with SQL 2008 R2. Im not aware if any backward compatibility problems. It will also work with SQL 2017 and Azure. SSDT is a tool used to develop SSAS, SSIS ...
Sir Swears-a-lot's user avatar
2 votes
Accepted

SSIS - Disable Task Based on Variable Value

I would add a script task at the beginning of the package, or right before the tasks in questions. The script task should: Take in the Variables (like User::IsCounterpartyReportRequired) Display ...
SQLDevDBA's user avatar
  • 2,244
2 votes

Is it ok to have huge page life expectancy?

Page Life Expectancy is simply how long (in seconds) a page will remain idle in the buffer before being removed to make room for another page. There's no active harm in a very large PLE. It's ...
RDFozz's user avatar
  • 11.6k
1 vote

SQL job using SSIS package takes a long time to run especially in the evenings

Though not really enough info here to give a full answer these steps are how I would approach trouble shooting this... check the execution logs for the package. Take note of the timings on steps. It ...
Ollie's user avatar
  • 738

Only top scored, non community-wiki answers of a minimum length are eligible