Brandie Tarvin (7/12/2013)

---

Yes, there is. Passport allows us to cross borders with other countries. ID could be anything...

Sean Lange (7/11/2013)

---

OK I will show my true American colors here. My wife's company just got a new client in Newfoundland. She is going to have to travel there this...

Where do you check the status?

Does this work?

SELECT

CON.AccountIdName,

CON.FirstName,

CON.LastName,

STC.Value

FROM dbo.Contact CON

LEFT OUTER JOIN StringMap STC

ON STC.attributename = 'new_coveragetype'...

Developer. (doesn't really matter for functionality, but developer tends to be a tad cheaper)

You can create only one config file that stores for example the servername and the database. And you can pass this config file along when calling the child packages...

Windows 7 has no problem with SQL Server or SSIS. My previous laptop had Windows 7 and I made a whole bunch of packages without an issue.

You need to run...

You don't need SQL Server itself installed on your pc to develop SSIS packages.

However, the error itself states the solution:

To install Integration Services, run SQL Server Setup and select Integration...

I think the error is coming from a job interview...

Did you put an expression on the Execute Package Task?

There can apparently be a lot of reasons for this error. Does the report work in BIDS?

Nice question Steve, definately learned something.

You can export this to CSV, but not to Excel.

What is the purpose of this export? If...

I think this is nearly impossible using TSQL only as there's no way of knowing if a space means the start of the last name, or if it is a...

Something like

WHERE myDateField <= DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)) -- last day of current month

AND myDateField =>...