[You don't need to have your sql instance in the DMZ. You would need to have your webserver in the DMZ but keep your data inside. Then you configure your...

I never knew you shouldn't? Is this a bad thing to do?

It is only for a couple of services which have externally facing customer websites as a front end to...

Ah .. so simple.

Thanks.. appreciated.

I have put a work around in place. I have changed the text qualifier from true to false in the package and then introduced to lines of code in the...

If you go to preview you see the data as "Data" as you would expect. All of the other entires are DATA

I have tried removing the flat file source and...

Eirikur Eiriksson (4/23/2014)

---

SQLSteve (4/22/2014)

---

As mentioned above, in the file it is showing as ""Data"" instead of "data".

The failing data has ""DATA"" around it, where as all of the lines...

As mentioned above, in the file it is showing as ""Data"" instead of "data".

The failing data has ""DATA"" around it, where as all of the lines before are "Data"...

If I open to file up in excel, it shows the data as DATA""

Where as all of the other entries are just DATA

John Mitchell-245523 (4/14/2014)

---

I would recommend that you use an unambiguous date format in your code, such as '20130512' for 12th May 2013, if you have the option.

You can set the...

Gila,

Any idea what settings might cause this? Collation is the same, language is the same on the instance, same on the databases.

Its causing quite a few issues as you would...

I have done two migrations recently where it has caused me an issue.

I restored a database from a SQL 2005 environment, in one of the tables, a field is smalldatetime...

Yep using snapshot replication. A new Snapshot is created just once a day over night.

Thanks for the reply.

Its not the snapshot which is running constantly, i think that would be impossible.

When you set the subscription up, theres an option to set the "agent...

Ah right ok. I never knew about formatteddatestring

Cheers!

I would check any config files your app has for sure, if anything uses the sa account for things like that then they will stop.

Internal objects owned by SA should...