The problem is, the full file could be partially wrong at times.

The source file has millions of rows, but only a subset of that data will be included in the ultimate destination table.  

And I agree, Hadoop is overkill. 

The thing is, we have no control over the actual import file, since it comes from an outside vendor.  However, maybe we can add the Transaction Date column as part...

By SQL Agent tables, you mean dbo.sysjobactivity? Let me check that out, I didn't know about this!

I guess my main question is, what's wrong with using something not officially documented? What are the risks?

Also, doesn't OpenRowset require a connection string? How does that affect...

Sorry, no updates yet.

That makes sense. I guess one can assume that the same project deployed to a new server should have the same number of rows, etc. Was anything done...

source = old system = SSAS 2012

destination = new system = SSAS 2016

Thanks for the feedback. By the way, what type of tools were used to confirm that source and destination were the same?

This is excellent, thanks!

I replaced the old command with something like this:

SQLCMD -S [Server Name] -U [login] -P [password] -Q”exec msdb.dbo.sp_start_job ‘[SQL JOB NAME]'”

I still haven't figured out how to get a good...

Sue_H (9/15/2016)

---

imani_technology (9/15/2016)

---

I have the following statement in a batch file. However, how can I get a return code to let me know the SQL Agent job ran successfully?

osql...

Let me re-phrase. We have existing SQL Agent jobs that process SSAS cubes. Has anyone used Control-M to launch the SQL Agent jobs to process SSAS cubes?

Sue_H (8/18/2016)

---

I hope the additional steps include some bench marking and baselines for the system resources when doing this as several other things take a hit when you do this....

By the way, I have three questions about the code

C:\DTEXEC -f test.dtsx > C:\folder\output.csv

1. PowerShell won't allow "&gt". Is that a typo?

2. How do I pass the...