Nice job Lowell.

Are you issuing a series of INSERT statements or are you using something like an OLE DB Destination from SSIS? If the former, then check the N prefix mentioned earlier....

Just curious, why are you choosing to add partitioning to your table?

Never heard of such a thing. Sounds like someone was under pressure to put something, anything, out there as a solution to a problem they could not solve, but what...

abhas (5/3/2013)

---

Hi All,

I am trying to run below simple query. I am trying to pass comma separated string into my query but its not working. if i pass single value...

I misread your PM. Sorry, I do...

To clarify,...

Just to add to what Jeffrey said, if performance is of primary concern and you have a little time to tune the SSIS you can play around with adjusting the...

Please do not cross-post. Direct replies here:

http://www.sqlservercentral.com/Forums/Topic1448864-364-1.aspx

Thanks for sharing your success story. I like that in the end you got a working solution that serves your users and your company well. That's what we do.

While I...

You will need to loop over *.* but inside the loop you can setup a dummy Script Task that has no custom code in it just for the sake of...

Try something like this instead:

Add-PSSnapin SqlServerCmdletSnapin100 -ErrorAction SilentlyContinue

Add-PSSnapin SqlServerProviderSnapin100 -ErrorAction SilentlyContinue

$searchTerm = "something"

# note the second entry is for a default instance so you would only change the word "server"...

Is this a recurring need?

If not, I do this kind of impact analysis using a multi-query window in SSMS and running a "find" proc that can search the metadata of...

System.Net.Mail

If you post your PowerShell code I can help you port it to VB.net which you can use inside a SSIS Script Task.