With the as400 v5r3 and above there is a validate metadata function in the ado.net connection used by SSIS. When this is mapped to a SQL Server datetime field it...

To continue Steve's comment one of the biggest issues with flat files restoration is maintaining all of the relationships. To use flat files you would also need complete and...

I have had to do this for auditing purposes before. The ledgers had to be backed and moved off site to provide an audit able change control for security.

I...

Roy Ernest (2/1/2010)

---

If you want to follow GSquared advice, I would advice to read up on Table partitioning first. There is a very good white paper on Table partitioning for...

I always use a domain user account since the agent is responsible for backup and we always backup to special backup file server on the network. This account is also...

John Burke-413068 (1/29/2010)

---

Lynn/Alan

Thanks for the info. There are no SSIS packages (thankfully). A couple more questions:

1. From what you have said it seems that restoring or attaching user databases from...

You are right I have gotten spoiled by having a virtual base SQL server image. Whenever I need a new server I just create a new virtual server and move...

I have been able to detach and reattach databases both ways. From 32 bit to 64 bit and back again. Quarterly I take the production databases from the 64 bit...

Another SSIS note: Script tasks are required to be compiled to the 64bit platform so they will need to be updated.

David has it right I was just going to point out that you can can evaluate the value of the destination table on the Precedence Constraint (the arrow between the...

Good question; I had forgotten about all of the pattern matching built into LIKE. I'll have to try to use it more.

This will be false for most of the world. The question didn't state we would all have to move to GMT to answer the question.

That would require a lot...

Another option is to look at the file as text. It is not too hard to parse out the SQL tranactions.

The connection information is at the top and the...

Sorry I couldn't be more help, but if you do gt it working well please post any tricks.

I never used the bulk insert task in the 1000+ packages I have written. I seem to recall a lot of issues in the forums so I skipped it. Instead...