CozyRock has a 3rd party Excel connector for SSIS that can connect to password protected Excel files.

The PowerShell solution is free and it probably won't kill you 🙂

So if I log into a coworkers computer using my own domain account, I can suddenly have more privileges because I'm using another IP? Awesome, this makes hacking so much...

Not really a fan of doing this in the database layer. If the result is NULL, you get...

There's a system SSIS variable called UserName that you can use.

CASE (Transact-SQL)

Phil Parkin (8/25/2013)

---

That may be so, but doing joins using the SQL Server engine is much faster than doing them in SSIS. So it may feel like a workaround, but...

You'll need to remove the password first. You can do this with PowerShell. This thread posts a solution:

http://www.sqlservercentral.com/Forums/Topic885800-148-1.aspx#bm888553

There is certainly overlap.

A good BI developer should be able to write decent TSQL.

He should also know about partitioning (to speed up ETL), indexes, recovery models and so on.

A database...

The variable is being re-evaluated every time. That's why you need to calculate it once (in a script task or execute sql task) and store the result in a variable,...

Take a look at this excellent article on how to concatenate row values:

Concatenating Row Values in Transact-SQL[/url]

Clustered index sorts on physical level.

Very nice question for a Monday (although I'm already answering this on Sunday evening :-D).

If you forget about this behaviour of table variables in production code...

The field of databases is quite big.

You have 3 main pillars regarding jobs: a DBA (the position Jeff talked about), a database developer and business intelligence.

My personal opinion is that...

The solutions seems quite simple:...

What has the environment variable to do with the command line? You specify a dtsconfig file directly.

What is the error that you get?