Archive | Visual Studio

Find Your SSRS Target Server URL

If you are looking to deploy your SSRS (SQL Server Reporting Service) reports directly from Visual Studio you will need to set the Target Server URL in the Properties of your project in the deployment section.  The trick here is that this is not the URL for your Report Manager. What you are in fact […]

Troubleshooting: SSIS Unable to retrieve column information from the data source. Make sure your target table in the database is available.

As soon as I saw this error message I guessed the problem was related to using a temp table. What was surprising was that the error message actually said this but I didn't realize it until by chance I cut and paste the message into another window.  Look below: Do you see the reference to […]

Troubleshooting: SSIS error 0x00084005 “the parameter type cannot be deduced because a single expression contains two untyped parameters @x and @P1”

This is one scary looking error message: SSIS error 0x00084005 "the parameter type cannot be deduced because a single expression contains two untyped parameters @x and @P1" It's terrifying enough to make you think maybe you should quit your SSIS development career altogether. But wait... What's this? Perhaps you're getting this message for the same […]

SSIS: There Are Some Mapping Errors On This Path – Troubleshooting

Dear SQL Server Integration Services Team, Would it be possible to get a more specific error message than "There are some mapping errors on this path"? Your friend, Phil The tricky problem with this error is getting enough information to troubleshoot it. Here's a nice trick for you: Run the package. Wait. What? Why would […]

SSIS Export To UTF-8 or UNIX (or how to set your code page to output a flat file for unix)

As more and more companies are moving to heterogenous environments with both windows and unix systems the life of the Microsoft SQL Server developer is becoming much more interesting. For our recent data warehouse project I was asked to create a SQL Server 2012 Integration Services (SSIS) ETL package to output a text file for […]

SSDT – Pre and Post Deploy Script Markers And Flava Flav

I admit, this post is primarily to provide a place for me to copy and paste my own code, but it's so sweet I figured some of you other SQL Server Data Tool Users might find it handy. When troubleshooting the generated deployment scripts I've always added a PRINT statement to indicate the beginning and […]

SSDT – The object reference differs only by case from the object definition warning

Well here's a Visual Studio SQL Server Data Tools (SSDT) warning I haven't come across before. I suspect the problem occurs only when performing a join to an external database reference dacpac. Luckily, the fix is simple (although a bit time consuming if you have very many of these warnings). First, the warning message will […]

SSDT VS 2012 – Bringing an existing database under source control

Alright! You are the hero of your database team! You've received the okay to start using SQL Server Data Tools to manage one of your existing databases. You think to yourself: "Within a few minutes I'll have the project up and running and I can move on to phase 2 of my plan to save […]

Where is vsdbcmd.exe in Visual Studio 2012!?!

Looking for your old friend vsdbcmd.exe in visual studio 2012? There's good news and bad news. The bad news is it's gone and it's not coming back. (see this MSDN thread if you don't believe me). The good news is there's a replacement: sqlpackage.exe The path for sqlpackage.exe is typically: C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin […]

Solution! SSIS Error: Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender

While running a 2012 SQL Server Integration Services package, the package ended up failing with the following message: Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender". The quickest and […]