Hello,

I can’t see any error in the details that you have posted.

Could you turn on logging for the Job Step (it’s an option on the Advanced Tab of the...

Good to hear that it worked out in the end 🙂

Hello Florian,

May be you should have checked the timestamps on the posts ….

Regards,

John Marsh

Hello Sam,

Obviously I don’t know your application (even whether it is DW or OLTP?), but you mention that a complex Select is used in many places, I just wonder then...

Hello again,

Did you ever get the import working?

If not, there is a simple example here:-

http://www.cryer.co.uk/brian/sqlserver/howtoimportcsv.htm

Regards,

John Marsh

Hello,

If your SA Login does not have a strong password then your SQL Server is not secure. Anyone who can access your network can do what they wish with your...

Hello again,

In the Export Wizard there is a screen called “Specify Table Copy or Query”. If you select the “Write a query to specify the data to transfer” you then...

Hello Ian,

That’s a shame.

A couple of posters in the same thread stated that deleting and recreating the Scripts fixed their problems. May be worth a try if there’s no other...

Hello again,

In SSMS (SQL Server Management Studio) right click on your Database and select “Tasks”, “Export Data…”

You can then run through the screens of the (Import and) Export Wizard to...

Hello,

Can you post an example of the details from the relevant SQL Server Log entries? Particularly the “Error, Severity, State” part.

Regards,

John Marsh

Hello,

Did you already spot his thread? May be the suggestions contained will work for you as well.

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/e95c1fda-bedb-4a8b-b90d-12c6c8779b30/

Regards,

John Marsh

Hello,

I couldn’t spot it mentioned in your post (may be I just missed it), so I just wanted to check if Dynamic Ports is turned on e.g. is there a...

Hello,

You could use the Export Wizard to perform the task once and save the procedure as an SSIS Package. There is an option to do this towards then end of...

Hello Sam,

May be creating a View based on your Select statement would save some coding?

If any parts of the various Where Clauses are common, then these could also be included...

Hello,

You may be able to simplify your query a little. Would it be true to say an Employee is “In” if they have a record in the CLOCKING_DETAILS Table with...