In the Flat File Source Editor you have areas you can select on the left: Connection Manager, Columns, Error Output. Select Error Output and then in the error column...

I don't think, based on BOL, that xp_cmdshell will ever return an @@ERROR code. If the command being executed by xp_cmdshell fails then the return value of xp_cmdshell will...

Have you tried configuring the error output so that it redirects any error rows? When I created a CSV out of your post, I get the warning but when...

Without seeing the file I'd guess that either your second line is missing some data or you have a blank line at the bottom of the file.

Mike,

I have to agree with Markus on this one. Performance Monitor does not do any writing to the database so it won't affect log size. I think removing...

Where did you save the Report Project(s)? On your pc or to a network share that was backed up by your network admins?

If you go to IIS Admin on...

What do you have the data stored in?

You can just do an SSIS package that loops through your server list and runs the query and updates a table.

If you have...

I'm pretty sure this is what you want:

[font="Courier New"]USE RonnieProd

GO

DROP TABLE #emp

CREATE TABLE #emp

(

        ID INT IDENTITY(1,1) NOT NULL,

             Initals [varchar](4),

        Name [varchar](50) NULL,

        FirstName [varchar](30) NULL,

        LastName [varchar](50) NULL

)

INSERT INTO #emp (Initals,[Name])

SELECT Initals,[Name]

FROM...

When connected to the serer you can run:

Select ServerProperty('edition')

David.Poole (9/10/2008)

---

I have to ask those of you who have worked mega-hours. Looking back, how much did it benefit your career? When I've worked the silly hours it...

I wrote an article on error handling in ssis that has code for this except I am creating XML. If you serch for error handling in ssis you should...

Exactly to which one? Both?

Where did you save your BIDS reporting project? The report definitions should be there.

Have you checked the Report Server error logs (SQL, Windows)?

One way to do it in SSRS is to use the ReportItems collection. You can reference the textbox that has each year value like this:

ReportItems!txtThisYearPlanned.Value = ReportItems!txtLastYearPlanned.Value

You may need...

I'm not sure what you mean by dynamically creating the password. Normally, if you only want your application to access SQL Server, you would use a SQL Login in...

There is no way I am aware of within SQL Server to restrict access to SQL Server based on IP or host name. I suppose in SQL Server 2005...