I'd like to learn more about SSIS as in coding, debugging, performance, etc. as it pertains to a DBA.

Jeff Moden (11/7/2013)

---

That's EXACTLY the problem I'm...

If you have fancy window dressing(s) but a weak foundation because you wanted to move into your house "yesterday". The foundation will crumble sooner. The house will be on jacks...

sqlmunkee (11/5/2013)

---

This is most likely the cause of the problem. 'dbo' has access to all objects in all schemas, so can do the DROP fine.

Do all users have...

Steve Jones - SSC Editor (10/18/2013)

---

Beatrix Kiddo (10/18/2013)

---

John Mitchell-245523 (10/18/2013)

---

Beatrix, where are you based? There should be a user group[/url] near you. There only about once a month,...

For the most part I don't. I save that for work and this forum...:-)

Attend User groups meetings and SQLSaturdays when I can. Use SQLServerCentral, SQLTeam, Google, Books, and Newsletters.

I decide what to dig into based on the current or next project I'm on...

We have a card with photo id, I carry mine on a lanyard with a reel so I don't have to bow to open the door. Not sure why they...

I was the accidental DBA and the developer at my last job, so 1:1.

At my current job it's 1:7.

aaron.reese (9/17/2013)

---

So is the source file missing data (i.e. are the lines of empty fields supposed to have data) or just extra lines.

If you are happy that the data is...

aaron.reese (9/16/2013)

---

I am going to hazard a guess that the CSV is generated from an Excel file and that there were 400K empty lines at the end of the CSV...

Phil Parkin (9/7/2013)

---

Sqlraider (9/6/2013)

---

I know very little about SSIS, so bear with me.

I have a SSIS package that inserts records into a 'staging' table from a CSV file (loading one...

Thank you for providing such a great site! I've learned so much from this site, not to mention the links to various blogs, free training, webcast, SQLSaturdays, etc.

I hope you...

Toreador (7/24/2013)

---

david.wright-948385 (7/24/2013)

---

Henk Schreij (7/24/2013)

---

The next disaster has struck.

Since July 17, the QOD (question of the day) has no "yesterday's answer" anymore. Why? :crying:

Please "consult" the responsible manager for these...

Chris,

I substituted this line in your code with this and it worked.

--AND a.DateABS BETWEEN ISNULL(x.StartDate,'19000101') AND t.EndDate

AND a.DateABS BETWEEN ISNULL(@FirstDay,'19000101') AND t.EndDate

@FirstDay was set to '2012-08-14'

This got me the desired...