sku370870 (2/11/2016)

---

CREATE TABLE #tblProjects

(

ProjectID int,

Project varchar(50)

...

Could be lots of things...this is a such a common class of problem Microsoft posted a KB article:

SSIS package does not run when called from a SQL Server Agent job...

mikefle (2/11/2016)

---

Does anyone have any views on what is the best file format to request data to be sent in?

We have a number of processes where files are sent to...

You should always be OK truncating a target staging table at any time. That is what staging tables are for.

It sounds like you should create a staging table on your...

Here is the logic to find the fiscal calendar year for those days at the beginning of January that are part of the last week in the previous year. The...

Microsoft only officially supports 2 versions back, so from SQL Server 2012 that would be back to SQL Server 2005. I see you are running with version 8.0 in your...

Here is a CLR string splitter from Adam Machanic. Original blog post.

----------------------------------------------------------------------------------------------------------------------------------------

-- drop objects

IF EXISTS ( SELECT *

...

I think the answer...

Customizing SQL Server Management Studio (SSMS)[/url]

Ed Wagner (2/10/2016)

---

Orlando Colamatteo (2/10/2016)

---

Luis Cazares (2/10/2016)

---

micang (2/10/2016)

---

Orlando Colamatteo (2/9/2016)

---

The performance of FORMAT is very poor when used over large sets of data which is unfortunate because the syntax is...

antonela (2/10/2016)

---

Thank you, this functions properly.

I found the solution at this link too:

http://geekswithblogs.net/stun/archive/2009/03/05/mapping-stored-procedure-parameters-in-ssis-ole-db-source-editor.aspx

But is it some way to test how many records return the stored procedure?I need to transfer data...

below86 (2/10/2016)

---

Please feel free to enlightened me.:-) But from what I've seen so far, only a couple weeks now, you can check in code in VCS but it isn't...

Change this

Parameters|Variables|Param Direction

0|User::Id|Input

to this

Parameters|Variables|Param Direction

@id|User::Id|Input

Luis Cazares (2/10/2016)

---

micang (2/10/2016)

---

Orlando Colamatteo (2/9/2016)

---

The performance of FORMAT is very poor when used over large sets of data which is unfortunate because the syntax is more readable than any...

A shared database where the guest user is granted execute permission to your function will be a clean solution transparent to all logins in the instance, even new ones. Synonyms...