If you view the metadata of the dataflow (double click the line coming out of your source) i assume that column shows up as a DT_WSTR.

If so use...

If I'm understanding, you want a timestamp (date time value) in your data to correspond to when the file was processed. The issue is you are getting multiple values since...

The main reason was security for powershell across multiple servers from the central management server. The powershell was intended to do health/performance monitoring. I'd need to verify this as this...

Thanks for the thoughts on this. I was in same boat regarding security, just wanted some feedback from the community.

There are no compelling reasons to change this so we'll...

This example will check 2 points compared to the zone.

Check the spatial results tab:

You can see the cars on the map as tiny dots, car1 about the center(inside the zone)...

komal145 (6/3/2016)

---

I created a package something like below attached picture.

1) execute task: sets the maxdays ( diff between startdate(getting from table) and getdate()) and sets to a variable in result...

If anyone out there has upgraded AD to 2012 and has 2008 sql servers did it work? what sort of investigation or testing did you do?

anything would be helpful.

Missing comma after subquery and the subquery doesnt have a SELECT clause.

SELECT

fld1

,fld2

,(SELECT max(something) from dbo.somewhere) as MaxOfSomething

,fld3

FROM dbo.SomewhereElse

OK that is weird then. I'll do some more experimenting then and see what i can figure out. Maybe i'm just missing something obvious.

Ok i had nothing specified for the run as user option on the advanced tab.

There is not options for...

Grant Fritchey (3/3/2016)

---

The account that runs the backup has to have permission to run the backup and it has to have permission on where the backup is going. If you...

djj (3/3/2016)

---

Are you talking about executing from a Job or command line or SSMS...?

From BOL:

"BACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and...

You are correct the default login was set with datareader to the old database on the prev server. Could have sworn i checked that, but that explains why it did...

I feel your pain brother!

You can have one file for everything, you just specify the xml file and pick "re-use existing" when you setup configs. But then you wont get the option to setup...