Editing the source could give you the same truncation error as the conversion does (unless you tell it to ignore truncation).

My preference would be derived column. Then you can...

Don't know much of this myself, but this may help:

http://technet.microsoft.com/en-us/library/cc280492.aspx

The table in that article tells you the type to expect depending on the type of connection and type of result...

not sure from that explanation what exactly you want.

But a note on outer joins that they will be overridden if you filter on an "outer" table in the where clause....

My list is still too long. ive done a couple SQLSaturdays and quite enjoyed them, and i always learn a lot of new things, but their other effect is...

Let me know what you decide as im in a similar spot ... though with likely git, not tfs.

there's nothing to ensure the objects in the SSIS catalog aren't rolled...

This argument seems to have devolved into competing viewpoints on what "a little clunky" means.

The original article was about a piece of software which was tested and meeting all established...

john.riley-1111039 (11/7/2013)

---

In Britain, we talk about 'Rolls-Royce solutions', usually as something to be avoided because of the cost in time and money. This is not to demean the...

Thanks for the effort, but I think you are right (its not better). What we had done before is set the connection string using an expression from a variable,...

Thanks for the suggestion, but it appears to still not work.

This feature would work for testing different environments in SSDT (for example, a different server name to connect to in...

Hi Phil,

I am using environments for when the project is published to the server (or will be, that is part of what I was setting up). ...

Edit: it looks like when compiling, both project level connection managers and parameter files get saved to disk. Seems like there still isn't a way to pass these...

You could start with an execute SQL task to query your calendar table for the current date (or current date - 1, not sure of your logic), and put the...

Can you post table definitions and some sample data?

How much of a salary decrease would you take for more vacation? Using Dave's number say you are making $40 an hour, for a 40 hour week thats $1,600....

There might be a better way. Im new to script transforms.

As I said, I'd load it into a staging table and then do it via tsql. Easier and...