Refresh schedule availability is based on the license level of PowerBI, but it can be refreshed manually more frequently.

I would question what utility refreshing that frequently actually has for...

you talking about power bi report server on prem or Power Bi service on cloud? if on prem scheduling is the same as with SSRS (PBIRS is a superset...

I'm really curious as to the why behind adding a checksum value to the table, based on a column named "Message", while then including the column named "Time", that somehow...

This is the primary cause of the problem.  If you have different...

Then I guess I have to ask just how many packages you have in a single project?   If that answer is more than 3, then I question the project design. ...

• This reply was modified 2 years, 11 months ago by sgmunson. Reason: Hit submit before I was done typing

Okay. so why are you using TFS, or for that matter, ANY kind of source control software, to manage SSIS projects?   I wouldn't do that unless I was being paid...

I finally found the solution.   While the "Editor" and "Advanced Editor" for the Flat File Destination do NOT have the ability to use an expression, it turns out that such...

I can't actually imagine why you would want to use the project deployment model and then try to use package deployments... that just doesn't make much sense.   There's no real...

Oh.. and I don't post anywhere near as often as I used to... and it's cause I'm a lot busier than I've ever been, so I hadn't even noticed that...

Turns out I was chasing an OLD problem... so it was kind of moot once I realized what was going on...  Our SSIS package had been ignoring a column entirely,...

Signature fixed to what it is supposed to be.

Thanks for the reply, Jeff...    I'll just have to do this manually then, as I don't really have the time right now to write the code...

As to my signature...

I can't wait for the 2022 Developer's Edition to come out so I can test.  I normally don't bother with public test versions and won't with 2022 either.  That...

That's some pretty awesome feedback, Steve.  Glad all of it worked out and thanks for posting what you did.  Glad the splitter and the modifications you made worked as...

Actually, you'll need the DBA to recreate the replication.   Steps are:

1.) Stop the existing replication.

2.) TRUNCATE the destination table.

3.) DBA sets up replication again between the two.

Once you are out...